{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["READ ME","Design Table","Proposed Velocity","Proposed Competence","Existing a","Existing b","Existing Competence","Existing Bank Erosion","Reference a","Reference b","Reference Competence","Reference Bank Erosion"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":162,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"READ ME","index":0,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,0,1,1],[2,0,2,1],[0,0,0,1],[6,0,6,1],[17,0,17,1]]}
["The Design Table Template"]
["The Design Table coincides with Phase 6 - Develop & Evaluate the Prelimanary Natural Channel Design.  You should complete the Design Table in the same sequence as outlined in Phase 6."]
["About the Design Table (see Blue-Tabbed Worksheet titled \"Design Table\"):"]
["1.","You can use the buttons at the top of the display for easy navigation."]
["2.","There are numerous formulas within the Design Table and therefore the cells are locked so that you don't accidently delete formulas; you can unlock the cells by unprotecting the worksheet under \"Tools\" and \"Protection\" (Excel 2003), or \"File\" and \"Permissions\" (Excel 2007/2010)."]
["3.","The bolded numbers in the Design Table coincide with the Entry numbers in Phase 6."]
["Completing the Design Table:"]
["1.","Computational Sequence 1 in Phase 6 is to organize the reference reach & existing reach data; the majority of this data has already been completed on other worksheets during the assessment phase and can be used by following the next steps."]
["2.","The Reference Reach column in the Design Table refers to the purple-tabbed worksheets titled \"Reference a\", \"Reference b\", \"Reference Competence\", and \"Reference Bank Erosion\"."]
["3.","The Existing Reach column in the Design Table refers to the orange-tabbed worksheets titled \"Existing a\", \"Existing b\", \"Existing Competence\", and \"Existing Bank Erosion\"."]
["4.","The orange- and purple-tabbed existing reach and reference reach worksheets must be completed to transfer the data to the Design Table; you can easily copy and paste already-completed worksheets into this workbook.  For example, highlight and copy an already-completed dimensionless ratios worksheet (same as \"Existing a\"), and paste into cell A1 in the \"Existing a\" worksheet in this workbook; do this for all the orange- and purple-tabbled worksheets."]
["5.","Not all the cells under the Reference Reach and Existing Reach columns in the Design Table will be completed by filling-in the orange- and purple-tabbled worksheets; thus you will need to complete these columns with supplemental information."]
["6.","Computational Sequence 2 in Phase 6 is to calculate riffle channel dimensions for the proposed design reach.  The first step is to obtain the bankfull discharge & corresponding cross-sectional area using the drainage area and regional curves (if applicable) from Phase 2; these variables are recorded in the Design Table, Entries 5, 9, and 4 in the Proposed Design Reach column)."]
["7.","Once the cross-sectional area is entered in the Design Table, many of the cells for channel dimensions and pattern in the Proposed Design Reach column will automatically compute because the formulas in these cells will have the necessary variables; these formulas are the same as the equations in Phase 6.  Note that the width of the flood-prone area and entrenchment ratio, however, must be computed for the Proposed Design Reach based on your design. "]
["8.","You must complete computational sequences 4, 5, 6, and 7."]
["9.","Computational Sequence 8 is to complete & evaluate hydraulic & sediment competency & capacity calculations.  The velocity and competence calculations for the Proposed Design Reach are automatically computed in the blue-tabbed worksheets \"Proposed Velocity\" and \"Proposed Competence\" using the variables in the Proposed Design Reach column in the Design Table.  However, in the \"Proposed Velocity\" tab, you will need to input a manning's n for the roughness coefficient method by relative roughness/friction factor and by stream type before the velocity and bankfull discharge is computed."]
["10. ","You must complete the capacity requirements and the remaining items in the computational sequence.  Note that the remaining bed feature dimensions, longitudinal maximum depths, and facet slopes will already be completed using the equations in Phase 6."]
["Important:  Following this sequence will give you a first estimate of the morphology of the proposed design reach based on the dimensionless ratios of the reference reach.  However, the user is advised to closely review the design variables to select the morphological values that best represent the boundary conditions of the proposed channel and requirements to meet specific objectives; sometimes the values for the proposed design reach will depart from the reference reach ratios.  Departure from the dimensionless ratios for natural channel design requires experience and judgement, but it is necessary to exercise appropriate options; selecting ratios blindly is never good practice. "]

{"sheet":"Design Table","index":1,"n_rows":421,"n_cols":11,"rows_kept":421,"cut":false,"hidden":false,"merged":[[389,5,390,6],[389,7,390,8],[391,1,392,1],[391,2,392,2],[391,3,392,4],[391,5,392,6],[391,7,392,8],[377,0,392,0],[385,1,386,1],[385,2,386,2],[385,3,386,4],[385,5,386,6],[385,7,386,8],[387,1,388,1],[387,2,388,2],[387,3,388,4],[387,5,388,6],[387,7,388,8],[381,1,382,1],[381,2,382,2],[381,3,382,4],[381,5,382,6],[381,7,382,8],[383,1,384,1],[383,2,384,2],[383,3,384,4],[383,5,384,6],[383,7,384,8],[389,1,390,1],[389,2,390,2],[389,3,390,4],[356,0,376,0],[360,3,360,4],[360,5,360,6],[360,7,360,8],[361,3,361,4],[361,5,361,6],[361,7,361,8],[362,3,362,4],[362,5,362,6],[362,7,362,8],[356,2,356,8],[357,3,357,4],[357,5,357,6],[357,7,357,8],[358,3,358,4],[358,5,358,6],[358,7,358,8],[376,3,376,4],[376,5,376,6],[262,7,263,8],[8,7,8,8],[373,5,373,6],[375,5,375,6],[365,7,365,8],[10,7,10,8],[9,7,9,8],[11,7,11,8],[266,5,266,6],[267,5,268,6],[396,5,396,6],[393,5,393,6],[258,5,259,6],[264,5,265,5],[264,6,265,6],[258,3,259,4],[396,7,396,8],[365,5,365,6],[366,5,366,6],[367,5,367,6],[365,3,365,4],[366,3,366,4],[371,7,371,8],[369,7,369,8],[364,7,364,8],[266,7,268,8],[368,7,368,8],[379,5,380,6],[373,7,373,8],[364,5,364,6],[368,5,368,6],[363,2,363,8],[374,7,374,8],[375,7,375,8],[0,10,4,14],[0,4,0,7],[7,3,7,4],[7,5,7,6],[8,3,8,4],[6,7,6,8],[7,7,7,8],[6,3,6,4],[6,5,6,6],[3,3,3,8],[0,0,0,2],[9,3,9,4],[275,0,280,0],[275,1,277,1],[275,2,277,2],[278,1,280,1],[278,2,280,2],[281,1,283,1],[281,2,283,2],[269,1,271,1],[269,2,271,2],[272,1,274,1],[272,2,274,2],[6,0,6,2],[5,0,5,2],[4,0,4,2],[4,3,4,8],[5,3,5,8],[258,7,259,8],[260,3,261,4],[260,5,261,6],[260,7,261,8],[262,3,263,4],[262,5,263,6],[240,2,242,2],[317,2,319,2],[287,2,289,2],[258,2,259,2],[260,2,261,2],[262,2,263,2],[266,2,268,2],[255,2,257,2],[243,2,245,2],[246,2,248,2],[249,2,251,2],[252,2,254,2],[264,2,265,2],[284,2,286,2],[299,2,301,2],[302,2,304,2],[305,2,307,2],[296,2,298,2],[314,2,316,2],[308,2,310,2],[311,2,313,2],[210,2,212,2],[213,2,215,2],[216,2,218,2],[204,2,206,2],[207,2,209,2],[198,2,200,2],[201,2,203,2],[195,2,197,2],[237,2,239,2],[219,2,221,2],[222,2,224,2],[225,2,227,2],[228,2,230,2],[231,2,233,2],[234,2,236,2],[168,2,170,2],[183,2,185,2],[186,2,188,2],[189,2,191,2],[177,2,179,2],[180,2,182,2],[171,2,173,2],[174,2,176,2],[192,2,194,2],[153,2,155,2],[159,2,161,2],[162,2,164,2],[165,2,167,2],[156,2,158,2],[141,2,143,2],[144,2,146,2],[147,2,149,2],[150,2,152,2],[296,0,325,0],[57,1,59,1],[60,1,62,1],[63,1,65,1],[66,1,68,1],[69,1,71,1],[72,1,74,1],[180,1,182,1],[150,1,152,1],[153,1,155,1],[159,1,161,1],[156,1,158,1],[147,1,149,1],[198,1,200,1],[201,1,203,1],[195,1,197,1],[162,1,164,1],[165,1,167,1],[168,1,170,1],[183,1,185,1],[171,1,173,1],[174,1,176,1],[177,1,179,1],[213,1,215,1],[210,0,257,0],[287,0,295,0],[326,0,355,0],[281,0,286,0],[258,0,268,0],[269,0,274,0],[87,0,107,0],[144,1,146,1],[141,1,143,1],[138,1,140,1],[216,1,218,1],[219,1,221,1],[222,1,224,1],[186,1,188,1],[189,1,191,1],[192,1,194,1],[210,1,212,1],[204,1,206,1],[207,1,209,1],[237,1,239,1],[240,1,242,1],[243,1,245,1],[246,1,248,1],[225,1,227,1],[36,0,56,0],[57,0,86,0],[45,1,47,1],[48,1,50,1],[51,1,53,1],[36,1,38,1],[84,1,86,1],[87,1,89,1],[90,1,92,1],[75,1,77,1],[78,1,80,1],[81,1,83,1],[54,1,56,1],[410,5,410,6],[405,3,405,4],[410,7,410,8],[406,5,406,6],[406,3,406,4],[408,5,408,6],[409,7,409,8],[407,7,407,8],[406,7,406,8],[408,7,408,8],[405,7,405,8],[409,5,409,6],[407,5,407,6],[409,3,409,4],[408,3,408,4],[102,1,104,1],[105,1,107,1],[228,1,230,1],[231,1,233,1],[234,1,236,1],[249,1,251,1],[252,1,254,1],[255,1,257,1],[287,1,289,1],[258,1,259,1],[260,1,261,1],[262,1,263,1],[264,1,265,1],[132,1,134,1],[135,1,137,1],[284,1,286,1],[404,5,404,6],[405,5,405,6],[407,3,407,4],[99,1,101,1],[314,1,316,1],[317,1,319,1],[308,1,310,1],[320,1,322,1],[63,2,65,2],[66,2,68,2],[69,2,71,2],[72,2,74,2],[75,2,77,2],[78,2,80,2],[81,2,83,2],[99,2,101,2],[102,2,104,2],[105,2,107,2],[375,3,375,4],[379,1,380,1],[377,1,378,1],[368,3,368,4],[311,1,313,1],[397,2,398,2],[403,7,403,8],[404,7,404,8],[403,5,403,6],[403,3,403,4],[293,1,295,1],[326,1,328,1],[329,1,331,1],[338,1,340,1],[332,1,334,1],[335,1,337,1],[302,1,304,1],[305,1,307,1],[320,2,322,2],[374,3,374,4],[374,5,374,6],[393,7,393,8],[379,7,380,8],[376,7,376,8],[379,3,380,4],[377,2,378,2],[379,2,380,2],[377,5,378,6],[377,7,378,8],[394,2,395,2],[399,2,400,2],[401,2,402,2],[406,0,410,0],[393,3,393,4],[396,3,396,4],[404,3,404,4],[410,3,410,4],[406,1,406,2],[394,1,395,1],[397,1,398,1],[399,1,400,1],[401,1,402,1],[296,1,298,1],[266,1,268,1],[350,1,352,1],[293,2,295,2],[335,2,337,2],[338,2,340,2],[341,2,343,2],[326,2,328,2],[329,2,331,2],[332,2,334,2],[344,2,346,2],[347,2,349,2],[350,2,352,2],[344,1,346,1],[347,1,349,1],[299,1,301,1],[323,2,325,2],[353,1,355,1],[353,2,355,2],[372,3,372,4],[372,5,372,6],[373,3,373,4],[369,3,369,4],[369,5,369,6],[370,2,370,8],[366,7,366,8],[372,7,372,8],[367,7,367,8],[359,3,359,4],[359,5,359,6],[359,7,359,8],[371,3,371,4],[371,5,371,6],[108,2,110,2],[87,2,89,2],[90,2,92,2],[93,2,95,2],[96,2,98,2],[132,2,134,2],[135,2,137,2],[138,2,140,2],[111,2,113,2],[123,2,125,2],[126,2,128,2],[129,2,131,2],[114,2,116,2],[21,1,23,1],[11,3,11,4],[11,5,11,6],[10,3,10,4],[10,5,10,6],[8,5,8,6],[9,5,9,6],[15,2,17,2],[18,2,20,2],[21,2,23,2],[12,1,14,1],[12,2,14,2],[15,1,17,1],[18,1,20,1],[416,0,420,0],[416,1,416,2],[108,0,134,0],[135,0,161,0],[27,1,29,1],[30,1,32,1],[54,2,56,2],[57,2,59,2],[33,1,35,1],[108,1,110,1],[42,2,44,2],[117,2,119,2],[120,1,122,1],[162,0,182,0],[393,0,405,0],[117,1,119,1],[42,1,44,1],[84,2,86,2],[45,2,47,2],[48,2,50,2],[51,2,53,2],[183,0,209,0],[93,1,95,1],[323,1,325,1],[96,1,98,1],[12,0,35,0],[24,2,26,2],[27,2,29,2],[30,2,32,2],[33,2,35,2],[266,3,268,4],[377,3,378,4],[367,3,367,4],[364,3,364,4],[24,1,26,1],[290,1,292,1],[290,2,292,2],[114,1,116,1],[123,1,125,1],[120,2,122,2],[111,1,113,1],[126,1,128,1],[129,1,131,1],[36,2,38,2],[39,1,41,1],[39,2,41,2],[60,2,62,2],[341,1,343,1],[416,7,416,8],[417,3,417,4],[417,5,417,6],[417,7,417,8],[420,7,420,8],[418,7,418,8],[419,3,419,4],[419,5,419,6],[419,7,419,8],[416,3,416,4],[416,5,416,6],[418,3,418,4],[418,5,418,6],[420,3,420,4],[420,5,420,6],[411,0,415,0],[411,1,411,2],[411,3,411,4],[411,5,411,6],[411,7,411,8],[412,3,412,4],[412,5,412,6],[412,7,412,8],[413,3,413,4],[413,5,413,6],[413,7,413,8],[414,3,414,4],[414,5,414,6],[414,7,414,8],[415,3,415,4],[415,5,415,6],[415,7,415,8]]}
[null,null,null,null,null,null,null,null,null,null,"NOTE:  Numerous cells contain formulas and therefore the cells are locked; to unlock cells, unprotect sheet under \"Tools\" & \"Protection\" (2003) or \"File\" & \"Permissions\" (2007/2010)"]
[null,null,{"$f":"IF('Existing a'!G38=\"\",\"\",'Existing a'!G38)","v":""}]
[]
[null,null,null,"\"Ave\" = Average   \"LL\" = Lower Limit    \"UL\" = Upper Limit"]
["Existing Reach Stream & Location:"]
["Reference Reach Stream & Location:"]
["Entry Number & Variable",null,null,"Existing Reach",null,"Proposed Design Reach",null,"Reference Reach"]
[null,1,"Landscape/Valley Type",{"$f":"IF('Existing a'!O2=\"\",\"\",'Existing a'!O2)","v":""},null,{"$f":"D8","v":""},null,{"$f":"IF('Reference a'!O2=\"\",\"\",'Reference a'!O2)","v":""}]
[null,2,"Valley Width (Wval)"]
[null,3,"Stream Type",{"$f":"IF('Existing a'!S2=\"\",\"\",'Existing a'!S2)","v":""},null,{"$f":"H10","v":""},null,{"$f":"IF('Reference a'!S2=\"\",\"\",'Reference a'!S2)","v":""}]
[null,4,"Drainage Area, mi2 (DA)",{"$f":"IF('Existing b'!R8=\"\",\"\",'Existing b'!R8)","v":""},null,{"$f":"D11","v":""},null,{"$f":"IF('Reference b'!R8=\"\",\"\",'Reference b'!R8)","v":""}]
[null,5,"Bankfull Discharge, cfs (Qbkf)",{"$f":"IF('Existing b'!L8=\"\",\"\",'Existing b'!L8)","v":""},null,null,null,{"$f":"IF('Reference b'!L8=\"\",\"\",'Reference b'!L8)","v":""}]
["Riffle Dimensions",6,"Riffle Width, ft (Wbkf)","Ave:",{"$f":"IF('Existing a'!G5=\"\",\"\",'Existing a'!G5)","v":""},"Ave:",{"$f":"IF(OR(G$22=\"\",I19=\"\"),\"\",(I19*G$22)^0.5)","v":""},"Ave:",{"$f":"IF('Reference a'!G5=\"\",\"\",'Reference a'!G5)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H5=\"\",\"\",'Existing a'!H5)","v":""},"LL:",{"$f":"IF(OR(G$22=\"\",I20=\"\"),\"\",(I20*G$22)^0.5)","v":""},"LL:",{"$f":"IF('Reference a'!H5=\"\",\"\",'Reference a'!H5)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I5=\"\",\"\",'Existing a'!I5)","v":""},"UL:",{"$f":"IF(OR(G$22=\"\",I21=\"\"),\"\",(I21*G$22)^0.5)","v":""},"UL:",{"$f":"IF('Reference a'!I5=\"\",\"\",'Reference a'!I5)","v":""}]
[null,7,"Riffle Mean Depth, ft (dbkf)","Ave:",{"$f":"IF('Existing a'!G7=\"\",\"\",'Existing a'!G7)","v":""},"Ave:",{"$f":"IF(OR(G$22=\"\",G$13=\"\"),\"\",G$22/G$13)","v":""},"Ave:",{"$f":"IF('Reference a'!G7=\"\",\"\",'Reference a'!G7)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H7=\"\",\"\",'Existing a'!H7)","v":""},"LL:",{"$f":"IF(OR(G$22=\"\",G$15=\"\"),\"\",G$22/G$15)","v":""},"LL:",{"$f":"IF('Reference a'!H7=\"\",\"\",'Reference a'!H7)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I7=\"\",\"\",'Existing a'!I7)","v":""},"UL:",{"$f":"IF(OR(G$22=\"\",G$14=\"\"),\"\",G$22/G$14)","v":""},"UL:",{"$f":"IF('Reference a'!I7=\"\",\"\",'Reference a'!I7)","v":""}]
[null,8,"Riffle Width/Depth Ratio (Wbkf/dbkf)","Ave:",{"$f":"IF('Existing a'!R7=\"\",\"\",'Existing a'!R7)","v":""},"Ave:",{"$f":"IF(OR(I19=\"\",G13=\"\"),\"\",I19)","v":""},"Ave:",{"$f":"IF('Reference a'!R7=\"\",\"\",'Reference a'!R7)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S7=\"\",\"\",'Existing a'!S7)","v":""},"LL:",{"$f":"IF(OR(I20=\"\",G13=\"\"),\"\",I20)","v":""},"LL:",{"$f":"IF('Reference a'!S7=\"\",\"\",'Reference a'!S7)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T7=\"\",\"\",'Existing a'!T7)","v":""},"UL:",{"$f":"IF(OR(I21=\"\",G13=\"\"),\"\",I21)","v":""},"UL:",{"$f":"IF('Reference a'!T7=\"\",\"\",'Reference a'!T7)","v":""}]
[null,9,"Riffle Cross-Sectional Area, ft2 (Abkf)","Ave:",{"$f":"IF('Existing a'!R5=\"\",\"\",'Existing a'!R5)","v":""},"Ave:",null,"Ave:",{"$f":"IF('Reference a'!R5=\"\",\"\",'Reference a'!R5)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S5=\"\",\"\",'Existing a'!S5)","v":""},null,null,"LL:",{"$f":"IF('Reference a'!S5=\"\",\"\",'Reference a'!S5)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T5=\"\",\"\",'Existing a'!T5)","v":""},null,null,"UL:",{"$f":"IF('Reference a'!T5=\"\",\"\",'Reference a'!T5)","v":""}]
[null,10,"Riffle Maximum Depth (dmax)","Ave:",{"$f":"IF('Existing a'!G9=\"\",\"\",'Existing a'!G9)","v":""},"Ave:",{"$f":"IF(OR(I28=\"\",G$16=\"\"),\"\",I28*G$16)","v":""},"Ave:",{"$f":"IF('Reference a'!G9=\"\",\"\",'Reference a'!G9)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H9=\"\",\"\",'Existing a'!H9)","v":""},"LL:",{"$f":"IF(OR(I29=\"\",G$16=\"\"),\"\",I29*G$16)","v":""},"LL:",{"$f":"IF('Reference a'!H9=\"\",\"\",'Reference a'!H9)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I9=\"\",\"\",'Existing a'!I9)","v":""},"UL:",{"$f":"IF(OR(I30=\"\",G$16=\"\"),\"\",I30*G$16)","v":""},"UL:",{"$f":"IF('Reference a'!I9=\"\",\"\",'Reference a'!I9)","v":""}]
[null,11,"Riffle Maximum Depth to Riffle Mean Depth (dmax/dbkf)        ","Ave:",{"$f":"IF('Existing a'!R9=\"\",\"\",'Existing a'!R9)","v":""},"Ave:",{"$f":"IF(OR(G$16=\"\",G25=\"\"),\"\",G25/G$16)","v":""},"Ave:",{"$f":"IF('Reference a'!R9=\"\",\"\",'Reference a'!R9)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S9=\"\",\"\",'Existing a'!S9)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G26=\"\"),\"\",G26/G$16)","v":""},"LL:",{"$f":"IF('Reference a'!S9=\"\",\"\",'Reference a'!S9)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T9=\"\",\"\",'Existing a'!T9)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G27=\"\"),\"\",G27/G$16)","v":""},"UL:",{"$f":"IF('Reference a'!T9=\"\",\"\",'Reference a'!T9)","v":""}]
[null,12,"Width of Flood-Prone Area at Elevation of 2 * dmax, ft (Wfpa)","Ave:",{"$f":"IF('Existing a'!G11=\"\",\"\",'Existing a'!G11)","v":""},"Ave:",null,"Ave:",{"$f":"IF('Reference a'!G11=\"\",\"\",'Reference a'!G11)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H11=\"\",\"\",'Existing a'!H11)","v":""},"LL:",null,"LL:",{"$f":"IF('Reference a'!H11=\"\",\"\",'Reference a'!H11)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I11=\"\",\"\",'Existing a'!I11)","v":""},"UL:",null,"UL:",{"$f":"IF('Reference a'!I11=\"\",\"\",'Reference a'!I11)","v":""}]
[null,13,"Entrenchment Ratio (Wfpa/Wbkf)","Ave:",{"$f":"IF('Existing a'!R11=\"\",\"\",'Existing a'!R11)","v":""},"Ave:",null,"Ave:",{"$f":"IF('Reference a'!R11=\"\",\"\",'Reference a'!R11)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S11=\"\",\"\",'Existing a'!S11)","v":""},"LL:",null,"LL:",{"$f":"IF('Reference a'!S11=\"\",\"\",'Reference a'!S11)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T11=\"\",\"\",'Existing a'!T11)","v":""},"UL:",null,"UL:",{"$f":"IF('Reference a'!T11=\"\",\"\",'Reference a'!T11)","v":""}]
["Riffle Inner Berm Dimensions",14,"Riffle Inner Berm Width, ft (Wib)","Ave:",{"$f":"IF('Existing a'!G13=\"\",\"\",'Existing a'!G13)","v":""},"Ave:",{"$f":"IF(OR(I40=\"\",G$13=\"\"),\"\",I40*G$13)","v":""},"Ave:",{"$f":"IF('Reference a'!G13=\"\",\"\",'Reference a'!G13)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H13=\"\",\"\",'Existing a'!H13)","v":""},"LL:",{"$f":"IF(OR(I41=\"\",G$13=\"\"),\"\",I41*G$13)","v":""},"LL:",{"$f":"IF('Reference a'!H13=\"\",\"\",'Reference a'!H13)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I13=\"\",\"\",'Existing a'!I13)","v":""},"UL:",{"$f":"IF(OR(I42=\"\",G$13=\"\"),\"\",I42*G$13)","v":""},"UL:",{"$f":"IF('Reference a'!I13=\"\",\"\",'Reference a'!I13)","v":""}]
[null,15,"Riffle Inner Berm Width to Riffle Width (Wib/Wbkf)","Ave:",{"$f":"IF('Existing a'!R13=\"\",\"\",'Existing a'!R13)","v":""},"Ave:",{"$f":"IF(OR(G$13=\"\",G37=\"\"),\"\",G37/G$13)","v":""},"Ave:",{"$f":"IF('Reference a'!R13=\"\",\"\",'Reference a'!R13)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S13=\"\",\"\",'Existing a'!S13)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",G38=\"\"),\"\",G38/G$13)","v":""},"LL:",{"$f":"IF('Reference a'!S13=\"\",\"\",'Reference a'!S13)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T13=\"\",\"\",'Existing a'!T13)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",G39=\"\"),\"\",G39/G$13)","v":""},"UL:",{"$f":"IF('Reference a'!T13=\"\",\"\",'Reference a'!T13)","v":""}]
[null,16,"Riffle Inner Berm Mean Depth, ft (dib)","Ave:",{"$f":"IF('Existing a'!G15=\"\",\"\",'Existing a'!G15)","v":""},"Ave:",{"$f":"IF(OR(I46=\"\",G$16=\"\"),\"\",I46*G$16)","v":""},"Ave:",{"$f":"IF('Reference a'!G15=\"\",\"\",'Reference a'!G15)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H15=\"\",\"\",'Existing a'!H15)","v":""},"LL:",{"$f":"IF(OR(I47=\"\",G$16=\"\"),\"\",I47*G$16)","v":""},"LL:",{"$f":"IF('Reference a'!H15=\"\",\"\",'Reference a'!H15)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I15=\"\",\"\",'Existing a'!I15)","v":""},"UL:",{"$f":"IF(OR(I48=\"\",G$16=\"\"),\"\",I48*G$16)","v":""},"UL:",{"$f":"IF('Reference a'!I15=\"\",\"\",'Reference a'!I15)","v":""}]
[null,17,"Riffle Inner Berm Mean Depth to Riffle Mean Depth (dib/dbkf)","Ave:",{"$f":"IF('Existing a'!R15=\"\",\"\",'Existing a'!R15)","v":""},"Ave:",{"$f":"IF(OR(G$16=\"\",G43=\"\"),\"\",G43/G$16)","v":""},"Ave:",{"$f":"IF('Reference a'!R15=\"\",\"\",'Reference a'!R15)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S15=\"\",\"\",'Existing a'!S15)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G44=\"\"),\"\",G44/G$16)","v":""},"LL:",{"$f":"IF('Reference a'!S15=\"\",\"\",'Reference a'!S15)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T15=\"\",\"\",'Existing a'!T15)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G45=\"\"),\"\",G45/G$16)","v":""},"UL:",{"$f":"IF('Reference a'!T15=\"\",\"\",'Reference a'!T15)","v":""}]
[null,18,"Riffle Inner Berm Width/Depth Ratio (Wib/dib)","Ave:",{"$f":"IF('Existing a'!G19=\"\",\"\",'Existing a'!G19)","v":""},"Ave:",{"$f":"IF(OR(I49=\"\",G13=\"\"),\"\",I49)","v":""},"Ave:",{"$f":"IF('Reference a'!G19=\"\",\"\",'Reference a'!G19)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H19=\"\",\"\",'Existing a'!H19)","v":""},"LL:",{"$f":"IF(OR(I50=\"\",G13=\"\"),\"\",I50)","v":""},"LL:",{"$f":"IF('Reference a'!H19=\"\",\"\",'Reference a'!H19)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I19=\"\",\"\",'Existing a'!I19)","v":""},"UL:",{"$f":"IF(OR(I51=\"\",G13=\"\"),\"\",I51)","v":""},"UL:",{"$f":"IF('Reference a'!I19=\"\",\"\",'Reference a'!I19)","v":""}]
[null,19,"Riffle Inner Berm Cross-Sectional Area (Aib)","Ave:",{"$f":"IF('Existing a'!G17=\"\",\"\",'Existing a'!G17)","v":""},"Ave:",{"$f":"IF(OR(I55=\"\",G$22=\"\"),\"\",I55*G$22)","v":""},"Ave:",{"$f":"IF('Reference a'!G17=\"\",\"\",'Reference a'!G17)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H17=\"\",\"\",'Existing a'!H17)","v":""},"LL:",{"$f":"IF(OR(I56=\"\",G$22=\"\"),\"\",I56*G$22)","v":""},"LL:",{"$f":"IF('Reference a'!H17=\"\",\"\",'Reference a'!H17)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I17=\"\",\"\",'Existing a'!I17)","v":""},"UL:",{"$f":"IF(OR(I57=\"\",G$22=\"\"),\"\",I57*G$22)","v":""},"UL:",{"$f":"IF('Reference a'!I17=\"\",\"\",'Reference a'!I17)","v":""}]
[null,20,"Riffle Inner Berm Cross-Sectional Area to Riffle Cross-Sectional Area (Aib/Abkf)","Ave:",{"$f":"IF('Existing a'!R17=\"\",\"\",'Existing a'!R17)","v":""},"Ave:",{"$f":"IF(OR(G$22=\"\",G52=\"\"),\"\",G52/G$22)","v":""},"Ave:",{"$f":"IF('Reference a'!R17=\"\",\"\",'Reference a'!R17)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S17=\"\",\"\",'Existing a'!S17)","v":""},"LL:",{"$f":"IF(OR(G$22=\"\",G53=\"\"),\"\",G53/G$22)","v":""},"LL:",{"$f":"IF('Reference a'!S17=\"\",\"\",'Reference a'!S17)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T17=\"\",\"\",'Existing a'!T17)","v":""},"UL:",{"$f":"IF(OR(G$22=\"\",G54=\"\"),\"\",G54/G$22)","v":""},"UL:",{"$f":"IF('Reference a'!T17=\"\",\"\",'Reference a'!T17)","v":""}]
["Pool Dimensions",21,"Pool Width, ft (Wbkfp)","Ave:",{"$f":"IF('Existing a'!G24=\"\",\"\",'Existing a'!G24)","v":""},"Ave:",{"$f":"IF(OR(I61=\"\",G$13=\"\"),\"\",I61*G$13)","v":""},"Ave:",{"$f":"IF('Reference a'!G24=\"\",\"\",'Reference a'!G24)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H24=\"\",\"\",'Existing a'!H24)","v":""},"LL:",{"$f":"IF(OR(I62=\"\",G$13=\"\"),\"\",I62*G$13)","v":""},"LL:",{"$f":"IF('Reference a'!H24=\"\",\"\",'Reference a'!H24)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I24=\"\",\"\",'Existing a'!I24)","v":""},"UL:",{"$f":"IF(OR(I63=\"\",G$13=\"\"),\"\",I63*G$13)","v":""},"UL:",{"$f":"IF('Reference a'!I24=\"\",\"\",'Reference a'!I24)","v":""}]
[null,22,"Pool Width to Riffle Width (Wbkfp/Wbkf)","Ave:",{"$f":"IF('Existing a'!R24=\"\",\"\",'Existing a'!R24)","v":""},"Ave:",{"$f":"IF(OR(G$13=\"\",G58=\"\"),\"\",G58/G$13)","v":""},"Ave:",{"$f":"IF('Reference a'!R24=\"\",\"\",'Reference a'!R24)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S24=\"\",\"\",'Existing a'!S24)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",G59=\"\"),\"\",G59/G$13)","v":""},"LL:",{"$f":"IF('Reference a'!S24=\"\",\"\",'Reference a'!S24)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T24=\"\",\"\",'Existing a'!T24)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",G60=\"\"),\"\",G60/G$13)","v":""},"UL:",{"$f":"IF('Reference a'!T24=\"\",\"\",'Reference a'!T24)","v":""}]
[null,23,"Pool Mean Depth, ft (dbkfp)","Ave:",{"$f":"IF('Existing a'!G26=\"\",\"\",'Existing a'!G26)","v":""},"Ave:",{"$f":"IF(OR(I67=\"\",G$16=\"\"),\"\",I67*G$16)","v":""},"Ave:",{"$f":"IF('Reference a'!G26=\"\",\"\",'Reference a'!G26)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H26=\"\",\"\",'Existing a'!H26)","v":""},"LL:",{"$f":"IF(OR(I68=\"\",G$16=\"\"),\"\",I68*G$16)","v":""},"LL:",{"$f":"IF('Reference a'!H26=\"\",\"\",'Reference a'!H26)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I26=\"\",\"\",'Existing a'!I26)","v":""},"UL:",{"$f":"IF(OR(I69=\"\",G$16=\"\"),\"\",I69*G$16)","v":""},"UL:",{"$f":"IF('Reference a'!I26=\"\",\"\",'Reference a'!I26)","v":""}]
[null,24,"Pool Mean Depth to Riffle Mean Depth (dbkfp/dbkf)","Ave:",{"$f":"IF('Existing a'!R26=\"\",\"\",'Existing a'!R26)","v":""},"Ave:",{"$f":"IF(OR(G$16=\"\",G64=\"\"),\"\",G64/G$16)","v":""},"Ave:",{"$f":"IF('Reference a'!R26=\"\",\"\",'Reference a'!R26)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S26=\"\",\"\",'Existing a'!S26)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G65=\"\"),\"\",G65/G$16)","v":""},"LL:",{"$f":"IF('Reference a'!S26=\"\",\"\",'Reference a'!S26)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T26=\"\",\"\",'Existing a'!T26)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G66=\"\"),\"\",G66/G$16)","v":""},"UL:",{"$f":"IF('Reference a'!T26=\"\",\"\",'Reference a'!T26)","v":""}]
[null,25,"Pool Width/Depth Ratio (Wbkfp/dbkfp)","Ave:",{"$f":"IF(OR(E$58=\"\",E$64=\"\"),\"\",E$58/E$64)","v":""},"Ave:",{"$f":"IF(OR(I70=\"\",G13=\"\"),\"\",I70)","v":""},"Ave:",{"$f":"IF(OR(I$58=\"\",I$64=\"\"),\"\",I$58/I$64)","v":""}]
[null,null,null,"LL:",{"$f":"IF(OR(E$59=\"\",E$66=\"\"),\"\",E$59/E$66)","v":""},"LL:",{"$f":"IF(OR(I71=\"\",G13=\"\"),\"\",I71)","v":""},"LL:",{"$f":"IF(OR(I$59=\"\",I$66=\"\"),\"\",I$59/I$66)","v":""}]
[null,null,null,"UL:",{"$f":"IF(OR(E$60=\"\",E$65=\"\"),\"\",E$60/E$65)","v":""},"UL:",{"$f":"IF(OR(I72=\"\",G13=\"\"),\"\",I72)","v":""},"UL:",{"$f":"IF(OR(I$60=\"\",I$65=\"\"),\"\",I$60/I$65)","v":""}]
[null,26,"Pool Cross-Sectional Area, ft2 (Abkfp)","Ave:",{"$f":"IF('Existing a'!G28=\"\",\"\",'Existing a'!G28)","v":""},"Ave:",{"$f":"IF(OR(G$22=\"\",I76=\"\"),\"\",I76*G$22)","v":""},"Ave:",{"$f":"IF('Reference a'!G28=\"\",\"\",'Reference a'!G28)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H28=\"\",\"\",'Existing a'!H28)","v":""},"LL:",{"$f":"IF(OR(G$22=\"\",I77=\"\"),\"\",I77*G$22)","v":""},"LL:",{"$f":"IF('Reference a'!H28=\"\",\"\",'Reference a'!H28)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I28=\"\",\"\",'Existing a'!I28)","v":""},"UL:",{"$f":"IF(OR(G$22=\"\",I78=\"\"),\"\",I78*G$22)","v":""},"UL:",{"$f":"IF('Reference a'!I28=\"\",\"\",'Reference a'!I28)","v":""}]
[null,27,"Pool Area to Riffle Area (Abkfp/Abkf)","Ave:",{"$f":"IF('Existing a'!R28=\"\",\"\",'Existing a'!R28)","v":""},"Ave:",{"$f":"IF(OR(G$22=\"\",G73=\"\"),\"\",G73/G$22)","v":""},"Ave:",{"$f":"IF('Reference a'!R28=\"\",\"\",'Reference a'!R28)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S28=\"\",\"\",'Existing a'!S28)","v":""},"LL:",{"$f":"IF(OR(G$22=\"\",G74=\"\"),\"\",G74/G$22)","v":""},"LL:",{"$f":"IF('Reference a'!S28=\"\",\"\",'Reference a'!S28)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T28=\"\",\"\",'Existing a'!T28)","v":""},"UL:",{"$f":"IF(OR(G$22=\"\",G75=\"\"),\"\",G75/G$22)","v":""},"UL:",{"$f":"IF('Reference a'!T28=\"\",\"\",'Reference a'!T28)","v":""}]
[null,28,"Pool Maximum Depth (dmaxp)","Ave:",{"$f":"IF('Existing a'!G30=\"\",\"\",'Existing a'!G30)","v":""},"Ave:",{"$f":"IF(OR(G$16=\"\",I82=\"\"),\"\",I82*G$16)","v":""},"Ave:",{"$f":"IF('Reference a'!G30=\"\",\"\",'Reference a'!G30)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H30=\"\",\"\",'Existing a'!H30)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",I83=\"\"),\"\",I83*G$16)","v":""},"LL:",{"$f":"IF('Reference a'!H30=\"\",\"\",'Reference a'!H30)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I30=\"\",\"\",'Existing a'!I30)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",I84=\"\"),\"\",I84*G$16)","v":""},"UL:",{"$f":"IF('Reference a'!I30=\"\",\"\",'Reference a'!I30)","v":""}]
[null,29,"Pool Maximum Depth to Riffle Mean Depth (dmaxp/dbkf)        ","Ave:",{"$f":"IF('Existing a'!R30=\"\",\"\",'Existing a'!R30)","v":""},"Ave:",{"$f":"IF(OR(G$16=\"\",G79=\"\"),\"\",G79/G$16)","v":""},"Ave:",{"$f":"IF('Reference a'!R30=\"\",\"\",'Reference a'!R30)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S30=\"\",\"\",'Existing a'!S30)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G80=\"\"),\"\",G80/G$16)","v":""},"LL:",{"$f":"IF('Reference a'!S30=\"\",\"\",'Reference a'!S30)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T30=\"\",\"\",'Existing a'!T30)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G81=\"\"),\"\",G81/G$16)","v":""},"UL:",{"$f":"IF('Reference a'!T30=\"\",\"\",'Reference a'!T30)","v":""}]
[null,30,"Point Bar Slope (Spb)","Ave:",{"$f":"IF('Existing a'!G38=\"\",\"\",'Existing a'!G38)","v":""},"Ave:",{"$f":"IF(OR(I85=\"\",G13=\"\"),\"\",I85)","v":""},"Ave:",{"$f":"IF('Reference a'!G38=\"\",\"\",'Reference a'!G38)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H38=\"\",\"\",'Existing a'!H38)","v":""},"LL:",{"$f":"IF(OR(I86=\"\",G13=\"\"),\"\",I86)","v":""},"LL:",{"$f":"IF('Reference a'!H38=\"\",\"\",'Reference a'!H38)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I38=\"\",\"\",'Existing a'!I38)","v":""},"UL:",{"$f":"IF(OR(I87=\"\",G13=\"\"),\"\",I87)","v":""},"UL:",{"$f":"IF('Reference a'!I38=\"\",\"\",'Reference a'!I38)","v":""}]
["Pool Inner Berm Dimensions",31,"Pool Inner Berm Width, ft (Wibp)","Ave:",{"$f":"IF('Existing a'!G32=\"\",\"\",'Existing a'!G32)","v":""},"Ave:",{"$f":"IF(OR(G$13=\"\",I91=\"\"),\"\",I91*G$13)","v":""},"Ave:",{"$f":"IF('Reference a'!G32=\"\",\"\",'Reference a'!G32)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H32=\"\",\"\",'Existing a'!H32)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",I92=\"\"),\"\",I92*G$13)","v":""},"LL:",{"$f":"IF('Reference a'!H32=\"\",\"\",'Reference a'!H32)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I32=\"\",\"\",'Existing a'!I32)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",I93=\"\"),\"\",I93*G$13)","v":""},"UL:",{"$f":"IF('Reference a'!I32=\"\",\"\",'Reference a'!I32)","v":""}]
[null,32,"Pool Inner Berm Width to Pool Width (Wibp/Wbkfp)","Ave:",{"$f":"IF('Existing a'!R32=\"\",\"\",'Existing a'!R32)","v":""},"Ave:",{"$f":"IF(OR(G$58=\"\",G88=\"\"),\"\",G88/G$58)","v":""},"Ave:",{"$f":"IF('Reference a'!R32=\"\",\"\",'Reference a'!R32)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S32=\"\",\"\",'Existing a'!S32)","v":""},"LL:",{"$f":"IF(OR(G$58=\"\",G89=\"\"),\"\",G89/G$58)","v":""},"LL:",{"$f":"IF('Reference a'!S32=\"\",\"\",'Reference a'!S32)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T32=\"\",\"\",'Existing a'!T32)","v":""},"UL:",{"$f":"IF(OR(G$58=\"\",G90=\"\"),\"\",G90/G$58)","v":""},"UL:",{"$f":"IF('Reference a'!T32=\"\",\"\",'Reference a'!T32)","v":""}]
[null,33,"Pool Inner Berm Mean Depth, ft (dibp)","Ave:",{"$f":"IF('Existing a'!G34=\"\",\"\",'Existing a'!G34)","v":""},"Ave:",{"$f":"IF(OR(G$64=\"\",I97=\"\"),\"\",I97*G$64)","v":""},"Ave:",{"$f":"IF('Reference a'!G34=\"\",\"\",'Reference a'!G34)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H34=\"\",\"\",'Existing a'!H34)","v":""},"LL:",{"$f":"IF(OR(G$64=\"\",I98=\"\"),\"\",I98*G$64)","v":""},"LL:",{"$f":"IF('Reference a'!H34=\"\",\"\",'Reference a'!H34)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I34=\"\",\"\",'Existing a'!I34)","v":""},"UL:",{"$f":"IF(OR(G$64=\"\",I99=\"\"),\"\",I99*G$64)","v":""},"UL:",{"$f":"IF('Reference a'!I34=\"\",\"\",'Reference a'!I34)","v":""}]
[null,34,"Pool Inner Berm Mean Depth to Pool Mean Depth (dibp/dbkfp)","Ave:",{"$f":"IF('Existing a'!R34=\"\",\"\",'Existing a'!R34)","v":""},"Ave:",{"$f":"IF(OR(G$64=\"\",G94=\"\"),\"\",G94/G$64)","v":""},"Ave:",{"$f":"IF('Reference a'!R34=\"\",\"\",'Reference a'!R34)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S34=\"\",\"\",'Existing a'!S34)","v":""},"LL:",{"$f":"IF(OR(G$64=\"\",G95=\"\"),\"\",G95/G$64)","v":""},"LL:",{"$f":"IF('Reference a'!S34=\"\",\"\",'Reference a'!S34)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T34=\"\",\"\",'Existing a'!T34)","v":""},"UL:",{"$f":"IF(OR(G$64=\"\",G96=\"\"),\"\",G96/G$64)","v":""},"UL:",{"$f":"IF('Reference a'!T34=\"\",\"\",'Reference a'!T34)","v":""}]
[null,35,"Pool Inner Berm Width/Depth Ratio (Wibp/dibp)","Ave:",{"$f":"IF('Existing a'!R38=\"\",\"\",'Existing a'!R38)","v":""},"Ave:",{"$f":"IF(OR(I100=\"\",G13=\"\"),\"\",I100)","v":""},"Ave:",{"$f":"IF('Reference a'!R38=\"\",\"\",'Reference a'!R38)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S38=\"\",\"\",'Existing a'!S38)","v":""},"LL:",{"$f":"IF(OR(I101=\"\",G13=\"\"),\"\",I101)","v":""},"LL:",{"$f":"IF('Reference a'!S38=\"\",\"\",'Reference a'!S38)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T38=\"\",\"\",'Existing a'!T38)","v":""},"UL:",{"$f":"IF(OR(I102=\"\",G13=\"\"),\"\",I102)","v":""},"UL:",{"$f":"IF('Reference a'!T38=\"\",\"\",'Reference a'!T38)","v":""}]
[null,36,"Pool Inner Berm Cross-Sectional Area (Aibp)","Ave:",{"$f":"IF('Existing a'!G36=\"\",\"\",'Existing a'!G36)","v":""},"Ave:",{"$f":"IF(OR(I106=\"\",G$73=\"\"),\"\",I106*G$73)","v":""},"Ave:",{"$f":"IF('Reference a'!G36=\"\",\"\",'Reference a'!G36)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H36=\"\",\"\",'Existing a'!H36)","v":""},"LL:",{"$f":"IF(OR(I107=\"\",G$73=\"\"),\"\",I107*G$73)","v":""},"LL:",{"$f":"IF('Reference a'!H36=\"\",\"\",'Reference a'!H36)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I36=\"\",\"\",'Existing a'!I36)","v":""},"UL:",{"$f":"IF(OR(I108=\"\",G$73=\"\"),\"\",I108*G$73)","v":""},"UL:",{"$f":"IF('Reference a'!I36=\"\",\"\",'Reference a'!I36)","v":""}]
[null,37,"Pool Inner Berm Cross-Sectional Area to Pool Cross-Sectional Area (Aibp/Abkfp)","Ave:",{"$f":"IF('Existing a'!R36=\"\",\"\",'Existing a'!R36)","v":""},"Ave:",{"$f":"IF(OR(G$73=\"\",G103=\"\"),\"\",G103/G$73)","v":""},"Ave:",{"$f":"IF('Reference a'!R36=\"\",\"\",'Reference a'!R36)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S36=\"\",\"\",'Existing a'!S36)","v":""},"LL:",{"$f":"IF(OR(G$73=\"\",G104=\"\"),\"\",G104/G$73)","v":""},"LL:",{"$f":"IF('Reference a'!S36=\"\",\"\",'Reference a'!S36)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T36=\"\",\"\",'Existing a'!T36)","v":""},"UL:",{"$f":"IF(OR(G$73=\"\",G105=\"\"),\"\",G105/G$73)","v":""},"UL:",{"$f":"IF('Reference a'!T36=\"\",\"\",'Reference a'!T36)","v":""}]
["Run Dimensions",38,"Run Width, ft (Wbkfr)","Ave:",{"$f":"IF('Existing a'!G43=\"\",\"\",'Existing a'!G43)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(I112=\"N/A\",\"N/A\",I112*G$13)))","v":""},"Ave:",{"$f":"IF('Reference a'!G43=\"\",\"\",'Reference a'!G43)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H43=\"\",\"\",'Existing a'!H43)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",I113=\"\"),\"\",I113*G$13)","v":""},"LL:",{"$f":"IF('Reference a'!H43=\"\",\"\",'Reference a'!H43)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I43=\"\",\"\",'Existing a'!I43)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",I114=\"\"),\"\",I114*G$13)","v":""},"UL:",{"$f":"IF('Reference a'!I43=\"\",\"\",'Reference a'!I43)","v":""}]
[null,39,"Run Width to Riffle Width (Wbkfr/Wbkf)","Ave:",{"$f":"IF('Existing a'!R43=\"\",\"\",'Existing a'!R43)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(G109=\"N/A\",\"N/A\",G109/G$13)))","v":""},"Ave:",{"$f":"IF('Reference a'!R43=\"\",\"\",'Reference a'!R43)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S43=\"\",\"\",'Existing a'!S43)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",G110=\"\"),\"\",G110/G$13)","v":""},"LL:",{"$f":"IF('Reference a'!S43=\"\",\"\",'Reference a'!S43)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T43=\"\",\"\",'Existing a'!T43)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",G111=\"\"),\"\",G111/G$13)","v":""},"UL:",{"$f":"IF('Reference a'!T43=\"\",\"\",'Reference a'!T43)","v":""}]
[null,40,"Run Mean Depth, ft (dbkfr)","Ave:",{"$f":"IF('Existing a'!G45=\"\",\"\",'Existing a'!G45)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(I118=\"N/A\",\"N/A\",I118*G$16)))","v":""},"Ave:",{"$f":"IF('Reference a'!G45=\"\",\"\",'Reference a'!G45)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H45=\"\",\"\",'Existing a'!H45)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",I119=\"\"),\"\",I119*G$16)","v":""},"LL:",{"$f":"IF('Reference a'!H45=\"\",\"\",'Reference a'!H45)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I45=\"\",\"\",'Existing a'!I45)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",I120=\"\"),\"\",I120*G$16)","v":""},"UL:",{"$f":"IF('Reference a'!I45=\"\",\"\",'Reference a'!I45)","v":""}]
[null,41,"Run Mean Depth to Riffle Mean Depth (dbkfr/dbkf)","Ave:",{"$f":"IF('Existing a'!R45=\"\",\"\",'Existing a'!R45)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(G115=\"N/A\",\"N/A\",G115/G$16)))","v":""},"Ave:",{"$f":"IF('Reference a'!R45=\"\",\"\",'Reference a'!R45)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S45=\"\",\"\",'Existing a'!S45)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G116=\"\"),\"\",G116/G$16)","v":""},"LL:",{"$f":"IF('Reference a'!S45=\"\",\"\",'Reference a'!S45)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T45=\"\",\"\",'Existing a'!T45)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G117=\"\"),\"\",G117/G$16)","v":""},"UL:",{"$f":"IF('Reference a'!T45=\"\",\"\",'Reference a'!T45)","v":""}]
[null,42,"Run Width/Depth Ratio (Wbkfr/dbkfr)","Ave:",{"$f":"IF('Existing a'!G51=\"\",\"\",'Existing a'!G51)","v":""},"Ave:",{"$f":"IF(OR(I121=\"\",G13=\"\"),\"\",I121)","v":""},"Ave:",{"$f":"IF('Reference a'!G51=\"\",\"\",'Reference a'!G51)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H51=\"\",\"\",'Existing a'!H51)","v":""},"LL:",{"$f":"IF(OR(I122=\"\",G13=\"\"),\"\",I22)","v":""},"LL:",{"$f":"IF('Reference a'!H51=\"\",\"\",'Reference a'!H51)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I51=\"\",\"\",'Existing a'!I51)","v":""},"UL:",{"$f":"IF(OR(I123=\"\",G13=\"\"),\"\",I23)","v":""},"UL:",{"$f":"IF('Reference a'!I51=\"\",\"\",'Reference a'!I51)","v":""}]
[null,43,"Run Cross-Sectional Area, ft2 (Abkfr)","Ave:",{"$f":"IF('Existing a'!G47=\"\",\"\",'Existing a'!G47)","v":""},"Ave:",{"$f":"IF(G$22=\"\",\"\",(IF(I127=\"N/A\",\"N/A\",I127*G$22)))","v":""},"Ave:",{"$f":"IF('Reference a'!G47=\"\",\"\",'Reference a'!G47)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H47=\"\",\"\",'Existing a'!H47)","v":""},"LL:",{"$f":"IF(OR(G$22=\"\",I128=\"\"),\"\",I128*G$22)","v":""},"LL:",{"$f":"IF('Reference a'!H47=\"\",\"\",'Reference a'!H47)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I47=\"\",\"\",'Existing a'!I47)","v":""},"UL:",{"$f":"IF(OR(G$22=\"\",I129=\"\"),\"\",I129*G$22)","v":""},"UL:",{"$f":"IF('Reference a'!I47=\"\",\"\",'Reference a'!I47)","v":""}]
[null,44,"Run Area to Riffle Area (Abkfr/Abkf)","Ave:",{"$f":"IF('Existing a'!R47=\"\",\"\",'Existing a'!R47)","v":""},"Ave:",{"$f":"IF(G$22=\"\",\"\",(IF(G124=\"N/A\",\"N/A\",G124/G$22)))","v":""},"Ave:",{"$f":"IF('Reference a'!R47=\"\",\"\",'Reference a'!R47)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S47=\"\",\"\",'Existing a'!S47)","v":""},"LL:",{"$f":"IF(OR(G$22=\"\",G125=\"\"),\"\",G125/G$22)","v":""},"LL:",{"$f":"IF('Reference a'!S47=\"\",\"\",'Reference a'!S47)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T47=\"\",\"\",'Existing a'!T47)","v":""},"UL:",{"$f":"IF(OR(G$22=\"\",G126=\"\"),\"\",G126/G$22)","v":""},"UL:",{"$f":"IF('Reference a'!T47=\"\",\"\",'Reference a'!T47)","v":""}]
[null,45,"Run Maximum Depth (dmaxr)","Ave:",{"$f":"IF('Existing a'!G49=\"\",\"\",'Existing a'!G49)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(I133=\"N/A\",\"N/A\",I133*G$16)))","v":""},"Ave:",{"$f":"IF('Reference a'!G49=\"\",\"\",'Reference a'!G49)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H49=\"\",\"\",'Existing a'!H49)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",I134=\"\"),\"\",I134*G$16)","v":""},"LL:",{"$f":"IF('Reference a'!H49=\"\",\"\",'Reference a'!H49)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I49=\"\",\"\",'Existing a'!I49)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",I135=\"\"),\"\",I135*G$16)","v":""},"UL:",{"$f":"IF('Reference a'!I49=\"\",\"\",'Reference a'!I49)","v":""}]
[null,46,"Run Maximum Depth to Riffle Mean Depth (dmaxr/dbkf)        ","Ave:",{"$f":"IF('Existing a'!R49=\"\",\"\",'Existing a'!R49)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(G130=\"N/A\",\"N/A\",G130/G$16)))","v":""},"Ave:",{"$f":"IF('Reference a'!R49=\"\",\"\",'Reference a'!R49)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S49=\"\",\"\",'Existing a'!S49)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G131=\"\"),\"\",G131/G$16)","v":""},"LL:",{"$f":"IF('Reference a'!S49=\"\",\"\",'Reference a'!S49)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T49=\"\",\"\",'Existing a'!T49)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G132=\"\"),\"\",G132/G$16)","v":""},"UL:",{"$f":"IF('Reference a'!T49=\"\",\"\",'Reference a'!T49)","v":""}]
["Glide Dimensions",47,"Glide Width, ft (Wbkfg)","Ave:",{"$f":"IF('Existing a'!G56=\"\",\"\",'Existing a'!G56)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(I139=\"N/A\",\"N/A\",I139*G$13)))","v":""},"Ave:",{"$f":"IF('Reference a'!G56=\"\",\"\",'Reference a'!G56)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H56=\"\",\"\",'Existing a'!H56)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",I140=\"\"),\"\",I140*G$13)","v":""},"LL:",{"$f":"IF('Reference a'!H56=\"\",\"\",'Reference a'!H56)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I56=\"\",\"\",'Existing a'!I56)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",I141=\"\"),\"\",I141*G$13)","v":""},"UL:",{"$f":"IF('Reference a'!I56=\"\",\"\",'Reference a'!I56)","v":""}]
[null,48,"Glide Width to Riffle Width (Wbkfg/Wbkf)","Ave:",{"$f":"IF('Existing a'!R56=\"\",\"\",'Existing a'!R56)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(G136=\"N/A\",\"N/A\",G136/G$13)))","v":""},"Ave:",{"$f":"IF('Reference a'!R56=\"\",\"\",'Reference a'!R56)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S56=\"\",\"\",'Existing a'!S56)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",G137=\"\"),\"\",G137/G$13)","v":""},"LL:",{"$f":"IF('Reference a'!S56=\"\",\"\",'Reference a'!S56)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T56=\"\",\"\",'Existing a'!T56)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",G138=\"\"),\"\",G138/G$13)","v":""},"UL:",{"$f":"IF('Reference a'!T56=\"\",\"\",'Reference a'!T56)","v":""}]
[null,49,"Glide Mean Depth, ft (dbkfg)","Ave:",{"$f":"IF('Existing a'!G58=\"\",\"\",'Existing a'!G58)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(I145=\"N/A\",\"N/A\",I145*G$16)))","v":""},"Ave:",{"$f":"IF('Reference a'!G58=\"\",\"\",'Reference a'!G58)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H58=\"\",\"\",'Existing a'!H58)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",I146=\"\"),\"\",I146*G$16)","v":""},"LL:",{"$f":"IF('Reference a'!H58=\"\",\"\",'Reference a'!H58)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I58=\"\",\"\",'Existing a'!I58)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",I147=\"\"),\"\",I147*G$16)","v":""},"UL:",{"$f":"IF('Reference a'!I58=\"\",\"\",'Reference a'!I58)","v":""}]
[null,50,"Glide Mean Depth to Riffle Mean Depth (dbkfg/dbkf)","Ave:",{"$f":"IF('Existing a'!R58=\"\",\"\",'Existing a'!R58)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(G142=\"N/A\",\"N/A\",G142/G$16)))","v":""},"Ave:",{"$f":"IF('Reference a'!R58=\"\",\"\",'Reference a'!R58)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S58=\"\",\"\",'Existing a'!S58)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G143=\"\"),\"\",G143/G$16)","v":""},"LL:",{"$f":"IF('Reference a'!S58=\"\",\"\",'Reference a'!S58)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T58=\"\",\"\",'Existing a'!T58)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G144=\"\"),\"\",G144/G$16)","v":""},"UL:",{"$f":"IF('Reference a'!T58=\"\",\"\",'Reference a'!T58)","v":""}]
[null,51,"Glide Width/Depth Ratio (Wbkfg/dbkfg)","Ave:",{"$f":"IF('Existing a'!G64=\"\",\"\",'Existing a'!G64)","v":""},"Ave:",{"$f":"IF(OR(I148=\"\",G13=\"\"),\"\",I148)","v":""},"Ave:",{"$f":"IF('Reference a'!G64=\"\",\"\",'Reference a'!G64)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H64=\"\",\"\",'Existing a'!H64)","v":""},"LL:",{"$f":"IF(OR(I149=\"\",G13=\"\"),\"\",I149)","v":""},"LL:",{"$f":"IF('Reference a'!H64=\"\",\"\",'Reference a'!H64)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I64=\"\",\"\",'Existing a'!I64)","v":""},"UL:",{"$f":"IF(OR(I150=\"\",G13=\"\"),\"\",I150)","v":""},"UL:",{"$f":"IF('Reference a'!I64=\"\",\"\",'Reference a'!I64)","v":""}]
[null,52,"Glide Cross-Sectional Area, ft2 (Abkfg)","Ave:",{"$f":"IF('Existing a'!G60=\"\",\"\",'Existing a'!G60)","v":""},"Ave:",{"$f":"IF(G$22=\"\",\"\",(IF(I154=\"N/A\",\"N/A\",I154*G$22)))","v":""},"Ave:",{"$f":"IF('Reference a'!G60=\"\",\"\",'Reference a'!G60)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H60=\"\",\"\",'Existing a'!H60)","v":""},"LL:",{"$f":"IF(OR(G$22=\"\",I155=\"\"),\"\",I155*G$22)","v":""},"LL:",{"$f":"IF('Reference a'!H60=\"\",\"\",'Reference a'!H60)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I60=\"\",\"\",'Existing a'!I60)","v":""},"UL:",{"$f":"IF(OR(G$22=\"\",I156=\"\"),\"\",I156*G$22)","v":""},"UL:",{"$f":"IF('Reference a'!I60=\"\",\"\",'Reference a'!I60)","v":""}]
[null,53,"Glide Area to Riffle Area (Abkfg/Abkf)","Ave:",{"$f":"IF('Existing a'!R60=\"\",\"\",'Existing a'!R60)","v":""},"Ave:",{"$f":"IF(G$22=\"\",\"\",(IF(G151=\"N/A\",\"N/A\",G151/G$22)))","v":""},"Ave:",{"$f":"IF('Reference a'!R60=\"\",\"\",'Reference a'!R60)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S60=\"\",\"\",'Existing a'!S60)","v":""},"LL:",{"$f":"IF(OR(G$22=\"\",G152=\"\"),\"\",G152/G$22)","v":""},"LL:",{"$f":"IF('Reference a'!S60=\"\",\"\",'Reference a'!S60)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T60=\"\",\"\",'Existing a'!T60)","v":""},"UL:",{"$f":"IF(OR(G$22=\"\",G153=\"\"),\"\",G153/G$22)","v":""},"UL:",{"$f":"IF('Reference a'!T60=\"\",\"\",'Reference a'!T60)","v":""}]
[null,54,"Glide Maximum Depth (dmaxg)","Ave:",{"$f":"IF('Existing a'!G62=\"\",\"\",'Existing a'!G62)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(I160=\"N/A\",\"N/A\",I160*G$16)))","v":""},"Ave:",{"$f":"IF('Reference a'!G62=\"\",\"\",'Reference a'!G62)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H62=\"\",\"\",'Existing a'!H62)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",I161=\"\"),\"\",I161*G$16)","v":""},"LL:",{"$f":"IF('Reference a'!H62=\"\",\"\",'Reference a'!H62)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I62=\"\",\"\",'Existing a'!I62)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",I162=\"\"),\"\",I162*G$16)","v":""},"UL:",{"$f":"IF('Reference a'!I62=\"\",\"\",'Reference a'!I62)","v":""}]
[null,55,"Glide Maximum Depth to Riffle Mean Depth (dmaxg/dbkf)        ","Ave:",{"$f":"IF('Existing a'!R62=\"\",\"\",'Existing a'!R62)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(G157=\"N/A\",\"N/A\",G157/G$16)))","v":""},"Ave:",{"$f":"IF('Reference a'!R62=\"\",\"\",'Reference a'!R62)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S62=\"\",\"\",'Existing a'!S62)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G158=\"\"),\"\",G158/G$16)","v":""},"LL:",{"$f":"IF('Reference a'!S62=\"\",\"\",'Reference a'!S62)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T62=\"\",\"\",'Existing a'!T62)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G159=\"\"),\"\",G159/G$16)","v":""},"UL:",{"$f":"IF('Reference a'!T62=\"\",\"\",'Reference a'!T62)","v":""}]
["Glide Inner Berm Dimensions",56,"Glide Inner Berm Width, ft (Wibg)","Ave:",{"$f":"IF('Existing a'!G66=\"\",\"\",'Existing a'!G66)","v":""},"Ave:",{"$f":"IF(G$136=\"\",\"\",(IF(I166=\"N/A\",\"N/A\",I166*G$136)))","v":""},"Ave:",{"$f":"IF('Reference a'!G66=\"\",\"\",'Reference a'!G66)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H66=\"\",\"\",'Existing a'!H66)","v":""},"LL:",{"$f":"IF(OR(G$136=\"\",I167=\"\"),\"\",I167*G$136)","v":""},"LL:",{"$f":"IF('Reference a'!H66=\"\",\"\",'Reference a'!H66)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I66=\"\",\"\",'Existing a'!I66)","v":""},"UL:",{"$f":"IF(OR(G$136=\"\",I168=\"\"),\"\",I168*G$136)","v":""},"UL:",{"$f":"IF('Reference a'!I66=\"\",\"\",'Reference a'!I66)","v":""}]
[null,57,"Glide Inner Berm Width to Glide Width (Wibg/Wbkfg)","Ave:",{"$f":"IF('Existing a'!R66=\"\",\"\",'Existing a'!R66)","v":""},"Ave:",{"$f":"IF(G$136=\"\",\"\",(IF(G163=\"N/A\",\"N/A\",G163/G$136)))","v":""},"Ave:",{"$f":"IF('Reference a'!R66=\"\",\"\",'Reference a'!R66)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S66=\"\",\"\",'Existing a'!S66)","v":""},"LL:",{"$f":"IF(OR(G$136=\"\",G164=\"\"),\"\",G164/G$136)","v":""},"LL:",{"$f":"IF('Reference a'!S66=\"\",\"\",'Reference a'!S66)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T66=\"\",\"\",'Existing a'!T66)","v":""},"UL:",{"$f":"IF(OR(G$136=\"\",G165=\"\"),\"\",G165/G$136)","v":""},"UL:",{"$f":"IF('Reference a'!T66=\"\",\"\",'Reference a'!T66)","v":""}]
[null,58,"Glide Inner Berm Mean Depth, ft (dibg)","Ave:",{"$f":"IF('Existing a'!G68=\"\",\"\",'Existing a'!G68)","v":""},"Ave:",{"$f":"IF(G$142=\"\",\"\",(IF(I172=\"N/A\",\"N/A\",I172*G$142)))","v":""},"Ave:",{"$f":"IF('Reference a'!G68=\"\",\"\",'Reference a'!G68)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H68=\"\",\"\",'Existing a'!H68)","v":""},"LL:",{"$f":"IF(OR(G$142=\"\",I173=\"\"),\"\",I173*G$142)","v":""},"LL:",{"$f":"IF('Reference a'!H68=\"\",\"\",'Reference a'!H68)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I68=\"\",\"\",'Existing a'!I68)","v":""},"UL:",{"$f":"IF(OR(G$142=\"\",I174=\"\"),\"\",I174*G$142)","v":""},"UL:",{"$f":"IF('Reference a'!I68=\"\",\"\",'Reference a'!I68)","v":""}]
[null,59,"Glide Inner Berm Mean Depth to Glide Mean Depth (dibg/dbkfg)","Ave:",{"$f":"IF('Existing a'!R68=\"\",\"\",'Existing a'!R68)","v":""},"Ave:",{"$f":"IF(G$142=\"\",\"\",(IF(G169=\"N/A\",\"N/A\",G169/G$142)))","v":""},"Ave:",{"$f":"IF('Reference a'!R68=\"\",\"\",'Reference a'!R68)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S68=\"\",\"\",'Existing a'!S68)","v":""},"LL:",{"$f":"IF(OR(G$142=\"\",G170=\"\"),\"\",G170/G$142)","v":""},"LL:",{"$f":"IF('Reference a'!S68=\"\",\"\",'Reference a'!S68)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T68=\"\",\"\",'Existing a'!T68)","v":""},"UL:",{"$f":"IF(OR(G$142=\"\",G171=\"\"),\"\",G171/G$142)","v":""},"UL:",{"$f":"IF('Reference a'!T68=\"\",\"\",'Reference a'!T68)","v":""}]
[null,60,"Glide Inner Berm Width/Depth Ratio (Wibg/dibg)","Ave:",{"$f":"IF('Existing a'!R64=\"\",\"\",'Existing a'!R64)","v":""},"Ave:",{"$f":"IF(OR(I175=\"\",G13=\"\"),\"\",I175)","v":""},"Ave:",{"$f":"IF('Reference a'!R64=\"\",\"\",'Reference a'!R64)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S64=\"\",\"\",'Existing a'!S64)","v":""},"LL:",{"$f":"IF(OR(I176=\"\",G13=\"\"),\"\",I176)","v":""},"LL:",{"$f":"IF('Reference a'!S64=\"\",\"\",'Reference a'!S64)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T64=\"\",\"\",'Existing a'!T64)","v":""},"UL:",{"$f":"IF(OR(I177=\"\",G13=\"\"),\"\",I177)","v":""},"UL:",{"$f":"IF('Reference a'!T64=\"\",\"\",'Reference a'!T64)","v":""}]
[null,61,"Glide Inner Berm Cross-Sectional Area (Aibg)","Ave:",{"$f":"IF('Existing a'!G70=\"\",\"\",'Existing a'!G70)","v":""},"Ave:",{"$f":"IF(G$151=\"\",\"\",(IF(I181=\"N/A\",\"N/A\",I181*G$151)))","v":""},"Ave:",{"$f":"IF('Reference a'!G70=\"\",\"\",'Reference a'!G70)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H70=\"\",\"\",'Existing a'!H70)","v":""},"LL:",{"$f":"IF(OR(G$151=\"\",I182=\"\"),\"\",I182*G$151)","v":""},"LL:",{"$f":"IF('Reference a'!H70=\"\",\"\",'Reference a'!H70)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I70=\"\",\"\",'Existing a'!I70)","v":""},"UL:",{"$f":"IF(OR(G$151=\"\",I183=\"\"),\"\",I183*G$151)","v":""},"UL:",{"$f":"IF('Reference a'!I70=\"\",\"\",'Reference a'!I70)","v":""}]
[null,62,"Glide Inner Berm Area to Glide Area (Aibg/Abkfg)","Ave:",{"$f":"IF('Existing a'!R70=\"\",\"\",'Existing a'!R70)","v":""},"Ave:",{"$f":"IF(G$151=\"\",\"\",(IF(G178=\"N/A\",\"N/A\",G178/G$151)))","v":""},"Ave:",{"$f":"IF('Reference a'!R70=\"\",\"\",'Reference a'!R70)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S70=\"\",\"\",'Existing a'!S70)","v":""},"LL:",{"$f":"IF(OR(G$151=\"\",G179=\"\"),\"\",G179/G$151)","v":""},"LL:",{"$f":"IF('Reference a'!S70=\"\",\"\",'Reference a'!S70)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T70=\"\",\"\",'Existing a'!T70)","v":""},"UL:",{"$f":"IF(OR(G$151=\"\",G180=\"\"),\"\",G180/G$151)","v":""},"UL:",{"$f":"IF('Reference a'!T70=\"\",\"\",'Reference a'!T70)","v":""}]
["Step Dimensions",63,"Step Width, ft (Wbkfs)","Ave:",{"$f":"IF('Existing a'!G75=\"\",\"\",'Existing a'!G75)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(I187=\"N/A\",\"N/A\",I187*G$13)))","v":""},"Ave:",{"$f":"IF('Reference a'!G75=\"\",\"\",'Reference a'!G75)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H75=\"\",\"\",'Existing a'!H75)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",I188=\"\"),\"\",I188*G$13)","v":""},"LL:",{"$f":"IF('Reference a'!H75=\"\",\"\",'Reference a'!H75)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I75=\"\",\"\",'Existing a'!I75)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",I189=\"\"),\"\",I189*G$13)","v":""},"UL:",{"$f":"IF('Reference a'!I75=\"\",\"\",'Reference a'!I75)","v":""}]
[null,64,"Step Width to Riffle Width (Wbkfs/Wbkf)","Ave:",{"$f":"IF('Existing a'!R75=\"\",\"\",'Existing a'!R75)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(G184=\"N/A\",\"N/A\",G184/G$13)))","v":""},"Ave:",{"$f":"IF('Reference a'!R75=\"\",\"\",'Reference a'!R75)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S75=\"\",\"\",'Existing a'!S75)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",G185=\"\"),\"\",G185/G$13)","v":""},"LL:",{"$f":"IF('Reference a'!S75=\"\",\"\",'Reference a'!S75)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T75=\"\",\"\",'Existing a'!T75)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",G186=\"\"),\"\",G186/G$13)","v":""},"UL:",{"$f":"IF('Reference a'!T75=\"\",\"\",'Reference a'!T75)","v":""}]
[null,65,"Step Mean Depth, ft (dbkfs)","Ave:",{"$f":"IF('Existing a'!G77=\"\",\"\",'Existing a'!G77)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(I193=\"N/A\",\"N/A\",I193*G$16)))","v":""},"Ave:",{"$f":"IF('Reference a'!G77=\"\",\"\",'Reference a'!G77)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H77=\"\",\"\",'Existing a'!H77)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",I194=\"\"),\"\",I194*G$16)","v":""},"LL:",{"$f":"IF('Reference a'!H77=\"\",\"\",'Reference a'!H77)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!H77=\"\",\"\",'Existing a'!H77)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",I195=\"\"),\"\",I195*G$16)","v":""},"UL:",{"$f":"IF('Reference a'!H77=\"\",\"\",'Reference a'!H77)","v":""}]
[null,66,"Step Mean Depth to Riffle Mean Depth (dbkfs/dbkf)","Ave:",{"$f":"IF('Existing a'!R77=\"\",\"\",'Existing a'!R77)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(G190=\"N/A\",\"N/A\",G190/G$16)))","v":""},"Ave:",{"$f":"IF('Reference a'!R77=\"\",\"\",'Reference a'!R77)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S77=\"\",\"\",'Existing a'!S77)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G191=\"\"),\"\",G191/G$16)","v":""},"LL:",{"$f":"IF('Reference a'!S77=\"\",\"\",'Reference a'!S77)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T77=\"\",\"\",'Existing a'!T77)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G192=\"\"),\"\",G192/G$16)","v":""},"UL:",{"$f":"IF('Reference a'!T77=\"\",\"\",'Reference a'!T77)","v":""}]
[null,67,"Step Width/Depth Ratio (Wbkfs/dbkfs)","Ave:",{"$f":"IF('Existing a'!G83=\"\",\"\",'Existing a'!G83)","v":""},"Ave:",{"$f":"IF(OR(I196=\"\",G13=\"\"),\"\",I196)","v":""},"Ave:",{"$f":"IF('Reference a'!G83=\"\",\"\",'Reference a'!G83)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H83=\"\",\"\",'Existing a'!H83)","v":""},"LL:",{"$f":"IF(OR(I197=\"\",G13=\"\"),\"\",I197)","v":""},"LL:",{"$f":"IF('Reference a'!H83=\"\",\"\",'Reference a'!H83)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I83=\"\",\"\",'Existing a'!I83)","v":""},"UL:",{"$f":"IF(OR(I198=\"\",G13=\"\"),\"\",I198)","v":""},"UL:",{"$f":"IF('Reference a'!I83=\"\",\"\",'Reference a'!I83)","v":""}]
[null,68,"Step Cross-Sectional Area, ft2 (Abkfs)","Ave:",{"$f":"IF('Existing a'!G79=\"\",\"\",'Existing a'!G79)","v":""},"Ave:",{"$f":"IF(G$22=\"\",\"\",(IF(I202=\"N/A\",\"N/A\",I202*G$22)))","v":""},"Ave:",{"$f":"IF('Reference a'!G79=\"\",\"\",'Reference a'!G79)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H79=\"\",\"\",'Existing a'!H79)","v":""},"LL:",{"$f":"IF(OR(G$22=\"\",I203=\"\"),\"\",I203*G$22)","v":""},"LL:",{"$f":"IF('Reference a'!H79=\"\",\"\",'Reference a'!H79)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I79=\"\",\"\",'Existing a'!I79)","v":""},"UL:",{"$f":"IF(OR(G$22=\"\",I204=\"\"),\"\",I204*G$22)","v":""},"UL:",{"$f":"IF('Reference a'!I79=\"\",\"\",'Reference a'!I79)","v":""}]
[null,69,"Step Area to Riffle Area (Abkfs/Abkf)","Ave:",{"$f":"IF('Existing a'!R79=\"\",\"\",'Existing a'!R79)","v":""},"Ave:",{"$f":"IF(G$22=\"\",\"\",(IF(G199=\"N/A\",\"N/A\",G199/G$22)))","v":""},"Ave:",{"$f":"IF('Reference a'!R79=\"\",\"\",'Reference a'!R79)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S79=\"\",\"\",'Existing a'!S79)","v":""},"LL:",{"$f":"IF(OR(G$22=\"\",G200=\"\"),\"\",G200/G$22)","v":""},"LL:",{"$f":"IF('Reference a'!S79=\"\",\"\",'Reference a'!S79)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T79=\"\",\"\",'Existing a'!T79)","v":""},"UL:",{"$f":"IF(OR(G$22=\"\",G201=\"\"),\"\",G201/G$22)","v":""},"UL:",{"$f":"IF('Reference a'!T79=\"\",\"\",'Reference a'!T79)","v":""}]
[null,70,"Step Maximum Depth (dmaxs)","Ave:",{"$f":"IF('Existing a'!G81=\"\",\"\",'Existing a'!G81)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(I208=\"N/A\",\"N/A\",I208*G$16)))","v":""},"Ave:",{"$f":"IF('Reference a'!G81=\"\",\"\",'Reference a'!G81)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!H81=\"\",\"\",'Existing a'!H81)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",I209=\"\"),\"\",I209*G$16)","v":""},"LL:",{"$f":"IF('Reference a'!H81=\"\",\"\",'Reference a'!H81)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!I81=\"\",\"\",'Existing a'!I81)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",I210=\"\"),\"\",I210*G$16)","v":""},"UL:",{"$f":"IF('Reference a'!I81=\"\",\"\",'Reference a'!I81)","v":""}]
[null,71,"Step Maximum Depth to Riffle Mean Depth (dmaxs/dbkf)        ","Ave:",{"$f":"IF('Existing a'!R81=\"\",\"\",'Existing a'!R81)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(G205=\"N/A\",\"N/A\",G205/G$16)))","v":""},"Ave:",{"$f":"IF('Reference a'!R81=\"\",\"\",'Reference a'!R81)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing a'!S81=\"\",\"\",'Existing a'!S81)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G206=\"\"),\"\",G206/G$16)","v":""},"LL:",{"$f":"IF('Reference a'!S81=\"\",\"\",'Reference a'!S81)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing a'!T81=\"\",\"\",'Existing a'!T81)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G207=\"\"),\"\",G207/G$16)","v":""},"UL:",{"$f":"IF('Reference a'!T81=\"\",\"\",'Reference a'!T81)","v":""}]
["Channel Pattern",72,"Linear Wavelength, ft (l)","Ave:",{"$f":"IF('Existing b'!F13=\"\",\"\",'Existing b'!F13)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(I214=\"N/A\",\"N/A\",I214*G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!F13=\"\",\"\",'Reference b'!F13)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G13=\"\",\"\",'Existing b'!G13)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",I215=\"\"),\"\",I215*G$13)","v":""},"LL:",{"$f":"IF('Reference b'!G13=\"\",\"\",'Reference b'!G13)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H13=\"\",\"\",'Existing b'!H13)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",I216=\"\"),\"\",I216*G$13)","v":""},"UL:",{"$f":"IF('Reference b'!H13=\"\",\"\",'Reference b'!H13)","v":""}]
[null,73,"Linear Wavelength to Riffle Width (l/Wbkf)","Ave:",{"$f":"IF('Existing b'!R13=\"\",\"\",'Existing b'!R13)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(G211=\"N/A\",\"N/A\",G211/G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!R13=\"\",\"\",'Reference b'!R13)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S13=\"\",\"\",'Existing b'!S13)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",G212=\"\"),\"\",G212/G$13)","v":""},"LL:",{"$f":"IF('Reference b'!S13=\"\",\"\",'Reference b'!S13)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T13=\"\",\"\",'Existing b'!T13)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",G213=\"\"),\"\",G213/G$13)","v":""},"UL:",{"$f":"IF('Reference b'!T13=\"\",\"\",'Reference b'!T13)","v":""}]
[null,74,"Stream Meander Length, ft (Lm)","Ave:",{"$f":"IF('Existing b'!F15=\"\",\"\",'Existing b'!F15)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(I220=\"N/A\",\"N/A\",I220*G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!F15=\"\",\"\",'Reference b'!F15)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G15=\"\",\"\",'Existing b'!G15)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",I221=\"\"),\"\",I221*G$13)","v":""},"LL:",{"$f":"IF('Reference b'!G15=\"\",\"\",'Reference b'!G15)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H15=\"\",\"\",'Existing b'!H15)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",I222=\"\"),\"\",I222*G$13)","v":""},"UL:",{"$f":"IF('Reference b'!H15=\"\",\"\",'Reference b'!H15)","v":""}]
[null,75,"Stream Meander Length Ratio (Lm/Wbkf)","Ave:",{"$f":"IF('Existing b'!R15=\"\",\"\",'Existing b'!R15)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(G217=\"N/A\",\"N/A\",G217/G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!R15=\"\",\"\",'Reference b'!R15)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S15=\"\",\"\",'Existing b'!S15)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",G218=\"\"),\"\",G218/G$13)","v":""},"LL:",{"$f":"IF('Reference b'!S15=\"\",\"\",'Reference b'!S15)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T15=\"\",\"\",'Existing b'!T15)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",G219=\"\"),\"\",G219/G$13)","v":""},"UL:",{"$f":"IF('Reference b'!T15=\"\",\"\",'Reference b'!T15)","v":""}]
[null,76,"Belt Width, ft (Wblt)","Ave:",{"$f":"IF('Existing b'!F19=\"\",\"\",'Existing b'!F19)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(I226=\"N/A\",\"N/A\",I226*G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!F19=\"\",\"\",'Reference b'!F19)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G19=\"\",\"\",'Existing b'!G19)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",I227=\"\"),\"\",I227*G$13)","v":""},"LL:",{"$f":"IF('Reference b'!G19=\"\",\"\",'Reference b'!G19)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H19=\"\",\"\",'Existing b'!H19)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",I228=\"\"),\"\",I228*G$13)","v":""},"UL:",{"$f":"IF('Reference b'!H19=\"\",\"\",'Reference b'!H19)","v":""}]
[null,77,"Meander Width Ratio (Wblt/Wbkf)","Ave:",{"$f":"IF('Existing b'!R19=\"\",\"\",'Existing b'!R19)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(G223=\"N/A\",\"N/A\",G223/G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!R19=\"\",\"\",'Reference b'!R19)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S19=\"\",\"\",'Existing b'!S19)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",G224=\"\"),\"\",G224/G$13)","v":""},"LL:",{"$f":"IF('Reference b'!S19=\"\",\"\",'Reference b'!S19)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T19=\"\",\"\",'Existing b'!T19)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",G225=\"\"),\"\",G225/G$13)","v":""},"UL:",{"$f":"IF('Reference b'!T19=\"\",\"\",'Reference b'!T19)","v":""}]
[null,78,"Radius of Curvature, ft (Rc)","Ave:",{"$f":"IF('Existing b'!F17=\"\",\"\",'Existing b'!F17)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(I232=\"N/A\",\"N/A\",I232*G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!F17=\"\",\"\",'Reference b'!F17)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G17=\"\",\"\",'Existing b'!G17)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",I233=\"\"),\"\",I233*G$13)","v":""},"LL:",{"$f":"IF('Reference b'!G17=\"\",\"\",'Reference b'!G17)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H17=\"\",\"\",'Existing b'!H17)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",I234=\"\"),\"\",I234*G$13)","v":""},"UL:",{"$f":"IF('Reference b'!H17=\"\",\"\",'Reference b'!H17)","v":""}]
[null,79,"Radius of Curvature to Riffle Width (Rc/Wbkf)","Ave:",{"$f":"IF('Existing b'!R17=\"\",\"\",'Existing b'!R17)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(G229=\"N/A\",\"N/A\",G229/G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!R17=\"\",\"\",'Reference b'!R17)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S17=\"\",\"\",'Existing b'!S17)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",G230=\"\"),\"\",G230/G$13)","v":""},"LL:",{"$f":"IF('Reference b'!S17=\"\",\"\",'Reference b'!S17)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T17=\"\",\"\",'Existing b'!T17)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",G231=\"\"),\"\",G231/G$13)","v":""},"UL:",{"$f":"IF('Reference b'!T17=\"\",\"\",'Reference b'!T17)","v":""}]
[null,80,"Arc Length, ft (La)","Ave:",{"$f":"IF('Existing b'!F21=\"\",\"\",'Existing b'!F21)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(I238=\"N/A\",\"N/A\",I238*G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!F21=\"\",\"\",'Reference b'!F21)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G21=\"\",\"\",'Existing b'!G21)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",I239=\"\"),\"\",I239*G$13)","v":""},"LL:",{"$f":"IF('Reference b'!G21=\"\",\"\",'Reference b'!G21)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H21=\"\",\"\",'Existing b'!H21)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",I240=\"\"),\"\",I240*G$13)","v":""},"UL:",{"$f":"IF('Reference b'!H21=\"\",\"\",'Reference b'!H21)","v":""}]
[null,81,"Arc Length to Riffle Width (La/Wbkf)","Ave:",{"$f":"IF('Existing b'!R21=\"\",\"\",'Existing b'!R21)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(G235=\"N/A\",\"N/A\",G235/G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!R21=\"\",\"\",'Reference b'!R21)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S21=\"\",\"\",'Existing b'!S21)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",G236=\"\"),\"\",G236/G$13)","v":""},"LL:",{"$f":"IF('Reference b'!S21=\"\",\"\",'Reference b'!S21)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T21=\"\",\"\",'Existing b'!T21)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",G237=\"\"),\"\",G237/G$13)","v":""},"UL:",{"$f":"IF('Reference b'!T21=\"\",\"\",'Reference b'!T21)","v":""}]
[null,82,"Riffle Length (Lr), ft","Ave:",{"$f":"IF('Existing b'!F23=\"\",\"\",'Existing b'!F23)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(I244=\"N/A\",\"N/A\",I244*G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!F23=\"\",\"\",'Reference b'!F23)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G23=\"\",\"\",'Existing b'!G23)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",I245=\"\"),\"\",I245*G$13)","v":""},"LL:",{"$f":"IF('Reference b'!G23=\"\",\"\",'Reference b'!G23)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H23=\"\",\"\",'Existing b'!H23)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",I246=\"\"),\"\",I246*G$13)","v":""},"UL:",{"$f":"IF('Reference b'!H23=\"\",\"\",'Reference b'!H23)","v":""}]
[null,83,"Riffle Length to Riffle Width (Lr/Wbkf)","Ave:",{"$f":"IF('Existing b'!R23=\"\",\"\",'Existing b'!R23)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(G241=\"N/A\",\"N/A\",G241/G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!R23=\"\",\"\",'Reference b'!R23)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S23=\"\",\"\",'Existing b'!S23)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",G242=\"\"),\"\",G242/G$13)","v":""},"LL:",{"$f":"IF('Reference b'!S23=\"\",\"\",'Reference b'!S23)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T23=\"\",\"\",'Existing b'!T23)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",G243=\"\"),\"\",G243/G$13)","v":""},"UL:",{"$f":"IF('Reference b'!T23=\"\",\"\",'Reference b'!T23)","v":""}]
[null,84,"Individual Pool Length, ft (Lp)","Ave:",{"$f":"IF('Existing b'!F25=\"\",\"\",'Existing b'!F25)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(I250=\"N/A\",\"N/A\",I250*G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!F25=\"\",\"\",'Reference b'!F25)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G25=\"\",\"\",'Existing b'!G25)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",I251=\"\"),\"\",I251*G$13)","v":""},"LL:",{"$f":"IF('Reference b'!G25=\"\",\"\",'Reference b'!G25)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H25=\"\",\"\",'Existing b'!H25)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",I252=\"\"),\"\",I252*G$13)","v":""},"UL:",{"$f":"IF('Reference b'!H25=\"\",\"\",'Reference b'!H25)","v":""}]
[null,85,"Pool Length to Riffle Width (Lp/Wbkf)","Ave:",{"$f":"IF('Existing b'!R25=\"\",\"\",'Existing b'!R25)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(G247=\"N/A\",\"N/A\",G247/G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!R25=\"\",\"\",'Reference b'!R25)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S25=\"\",\"\",'Existing b'!S25)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",G248=\"\"),\"\",G248/G$13)","v":""},"LL:",{"$f":"IF('Reference b'!S25=\"\",\"\",'Reference b'!S25)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T25=\"\",\"\",'Existing b'!T25)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",G249=\"\"),\"\",G249/G$13)","v":""},"UL:",{"$f":"IF('Reference b'!T25=\"\",\"\",'Reference b'!T25)","v":""}]
[null,86,"Pool-to-Pool Spacing, ft (Ps)","Ave:",{"$f":"IF('Existing b'!F27=\"\",\"\",'Existing b'!F27)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(I256=\"N/A\",\"N/A\",I256*G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!F27=\"\",\"\",'Reference b'!F27)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G27=\"\",\"\",'Existing b'!G27)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",I257=\"\"),\"\",I257*G$13)","v":""},"LL:",{"$f":"IF('Reference b'!G27=\"\",\"\",'Reference b'!G27)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H27=\"\",\"\",'Existing b'!H27)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",I258=\"\"),\"\",I258*G$13)","v":""},"UL:",{"$f":"IF('Reference b'!H27=\"\",\"\",'Reference b'!H27)","v":""}]
[null,87,"Pool-to-Pool Spacing to Riffle Width (Ps/Wbkf)","Ave:",{"$f":"IF('Existing b'!R27=\"\",\"\",'Existing b'!R27)","v":""},"Ave:",{"$f":"IF(G$13=\"\",\"\",(IF(G253=\"N/A\",\"N/A\",G253/G$13)))","v":""},"Ave:",{"$f":"IF('Reference b'!R27=\"\",\"\",'Reference b'!R27)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S27=\"\",\"\",'Existing b'!S27)","v":""},"LL:",{"$f":"IF(OR(G$13=\"\",G254=\"\"),\"\",G254/G$13)","v":""},"LL:",{"$f":"IF('Reference b'!S27=\"\",\"\",'Reference b'!S27)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T27=\"\",\"\",'Existing b'!T27)","v":""},"UL:",{"$f":"IF(OR(G$13=\"\",G255=\"\"),\"\",G255/G$13)","v":""},"UL:",{"$f":"IF('Reference b'!T27=\"\",\"\",'Reference b'!T27)","v":""}]
["Sinuosity and Slope",88,"Stream Length (SL)",{"$f":"IF('Existing b'!E33=\"\",\"\",'Existing b'!E33)","v":""},null,null,null,{"$f":"IF('Reference b'!E33=\"\",\"\",'Reference b'!E33)","v":""}]
[]
[null,89,"Valley Length (VL)",{"$f":"IF('Existing b'!N33=\"\",\"\",'Existing b'!N33)","v":""},null,null,null,{"$f":"IF('Reference b'!N33=\"\",\"\",'Reference b'!N33)","v":""}]
[]
[null,90,"Valley Slope (Sval)",{"$f":"IF('Existing b'!E31=\"\",\"\",'Existing b'!E31)","v":""},null,null,null,{"$f":"IF('Reference b'!E31=\"\",\"\",'Reference b'!E31)","v":""}]
[]
[null,91,"Sinuosity (k)","SL/VL:",{"$f":"IF('Existing b'!T33=\"\",\"\",'Existing b'!T33)","v":""},"SL/VL:",{"$f":"IF(OR(F259=\"\",F261=\"\"),\"\",F259/F261)","v":""},"SL/VL:",{"$f":"IF('Reference b'!T33=\"\",\"\",'Reference b'!T33)","v":""}]
[null,null,null,"VS/S:",{"$f":"IF('Existing b'!T31=\"\",\"\",'Existing b'!T31)","v":""},null,null,"VS/S:",{"$f":"IF('Reference b'!T31=\"\",\"\",'Reference b'!T31)","v":""}]
[null,92,"Average Water Surface Slope (S)",{"$f":"IF('Existing b'!N31=\"\",\"\",'Existing b'!N31)","v":""},null,"S = Sval/k",null,{"$f":"IF('Reference b'!N31=\"\",\"\",'Reference b'!N31)","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(G265=\"\",F263=\"\"),\"\",F263/G265)","v":""}]
[]
["Floodplain",93,"Floodplain Width, ft (Wf)","Ave:",null,"Ave:",null,"Ave:"]
[null,null,null,"LL:",null,"LL:",null,"LL:"]
[null,null,null,"UL:",null,"UL:",null,"UL:"]
[null,94,"Floodplain Surface Depth Limit, ft (df)","Ave:",null,"Ave:",null,"Ave:"]
[null,null,null,"LL:",null,"LL:",null,"LL:"]
[null,null,null,"UL:",null,"UL:",null,"UL:"]
["Low Terrace",95,"Low Terrace Width, ft (Wlt)","Ave:",null,"Ave:",null,"Ave:"]
[null,null,null,"LL:",null,"LL:",null,"LL:"]
[null,null,null,"UL:",null,"UL:",null,"UL:"]
[null,96,"Low Terrace Surface Depth Limit, ft (dlt)","Ave:",null,"Ave:",null,"Ave:"]
[null,null,null,"LL:",null,"LL:",null,"LL:"]
[null,null,null,"UL:",null,"UL:",null,"UL:"]
["Flood-Prone Area",97,"Flood-Prone Area Width, ft (Wfpa)","Ave:",null,"Ave:",null,"Ave:"]
[null,null,null,"LL:",null,"LL:",null,"LL:"]
[null,null,null,"UL:",null,"UL:",null,"UL:"]
[null,98,"Flood-Prone Area Surface Depth Limit, ft (dfpa)","Ave:",null,"Ave:",null,"Ave:"]
[null,null,null,"LL:",null,"LL:",null,"LL:"]
[null,null,null,"UL:",null,"UL:",null,"UL:"]
["Degree of Incision",99,"Low Bank Height (LBH)","Ave:",{"$f":"IF('Existing b'!F35=\"\",\"\",AVERAGE(E289:E290))","v":""},"Ave:",null,"Ave:",{"$f":"IF('Reference b'!F35=\"\",\"\",AVERAGE(I289:I290))","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!F35=\"\",\"\",IF('Existing b'!F35<'Existing b'!F36,'Existing b'!F35,'Existing b'!F36))","v":""},"LL:",null,"LL:",{"$f":"IF('Reference b'!F35=\"\",\"\",IF('Reference b'!F35<'Reference b'!F36,'Reference b'!F35,'Reference b'!F36))","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!F36=\"\",\"\",IF('Existing b'!F36>'Existing b'!F35,'Existing b'!F36,'Existing b'!F35))","v":""},"UL:",null,"UL:",{"$f":"IF('Reference b'!F36=\"\",\"\",IF('Reference b'!F36>'Reference b'!F35,'Reference b'!F36,'Reference b'!F35))","v":""}]
[null,100,"Maximum Bankfull Depth (dmax) at Same Location as Low Bank Height (LBH) Measurement","Ave:",{"$f":"IF('Existing b'!M35=\"\",\"\",AVERAGE(E292:E293))","v":""},"Ave:",null,"Ave:",{"$f":"IF('Reference b'!M35=\"\",\"\",AVERAGE(I292:I293))","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!M35=\"\",\"\",IF('Existing b'!M35<'Existing b'!M36,'Existing b'!M35,'Existing b'!M36))","v":""},"LL:",null,"LL:",{"$f":"IF('Reference b'!M35=\"\",\"\",IF('Reference b'!M35<'Reference b'!M36,'Reference b'!M35,'Reference b'!M36))","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!M36=\"\",\"\",IF('Existing b'!M36>'Existing b'!M35,'Existing b'!M36,'Existing b'!M35))","v":""},"UL:",null,"UL:",{"$f":"IF('Reference b'!M36=\"\",\"\",IF('Reference b'!M36>'Reference b'!M35,'Reference b'!M36,'Reference b'!M35))","v":""}]
[null,101,"Bank-Height Ratio (LBH/dmax)","Ave:",{"$f":"IF('Existing b'!T35=\"\",\"\",AVERAGE(E295:E296))","v":""},"Ave:",null,"Ave:",{"$f":"IF('Reference b'!T35=\"\",\"\",AVERAGE(I295:I296))","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!T35=\"\",\"\",IF('Existing b'!T35<'Existing b'!T36,'Existing b'!T35,'Existing b'!T36))","v":""},"LL:",null,"LL:",{"$f":"IF('Reference b'!T35=\"\",\"\",IF('Reference b'!T35<'Reference b'!T36,'Reference b'!T35,'Reference b'!T36))","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T35=\"\",\"\",IF('Existing b'!T36>'Existing b'!T35,'Existing b'!T36,'Existing b'!T35))","v":""},"UL:",null,"UL:",{"$f":"IF('Reference b'!T36=\"\",\"\",IF('Reference b'!T36>'Reference b'!T35,'Reference b'!T36,'Reference b'!T35))","v":""}]
["Bed Feature Max Depth Measurements and Dimensionless Ratios from Profile",102,"Riffle Maximum Depth, ft (dmax)","Ave:",{"$f":"IF('Existing b'!F50=\"\",\"\",'Existing b'!F50)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(I300=\"N/A\",\"N/A\",I300*G$16)))","v":""},"Ave:",{"$f":"IF('Reference b'!F50=\"\",\"\",'Reference b'!F50)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G50=\"\",\"\",'Existing b'!G50)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",I301=\"\"),\"\",I301*G$16)","v":""},"LL:",{"$f":"IF('Reference b'!G50=\"\",\"\",'Reference b'!G50)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H50=\"\",\"\",'Existing b'!H50)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",I302=\"\"),\"\",I302*G$16)","v":""},"UL:",{"$f":"IF('Reference b'!H50=\"\",\"\",'Reference b'!H50)","v":""}]
[null,103,"Riffle Maximum Depth to Riffle Mean Depth (dmax/dbkf)","Ave:",{"$f":"IF('Existing b'!R50=\"\",\"\",'Existing b'!R50)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(G297=\"N/A\",\"N/A\",G297/G$16)))","v":""},"Ave:",{"$f":"IF('Reference b'!R50=\"\",\"\",'Reference b'!R50)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S50=\"\",\"\",'Existing b'!S50)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G298=\"\"),\"\",G298/G$16)","v":""},"LL:",{"$f":"IF('Reference b'!S50=\"\",\"\",'Reference b'!S50)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T50=\"\",\"\",'Existing b'!T50)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G299=\"\"),\"\",G299/G$16)","v":""},"UL:",{"$f":"IF('Reference b'!T50=\"\",\"\",'Reference b'!T50)","v":""}]
[null,104,"Pool Maximum Depth, ft (dmaxp)","Ave:",{"$f":"IF('Existing b'!F54=\"\",\"\",'Existing b'!F54)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(I306=\"N/A\",\"N/A\",I306*G$16)))","v":""},"Ave:",{"$f":"IF('Reference b'!F54=\"\",\"\",'Reference b'!F54)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G54=\"\",\"\",'Existing b'!G54)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",I307=\"\"),\"\",I307*G$16)","v":""},"LL:",{"$f":"IF('Reference b'!G54=\"\",\"\",'Reference b'!G54)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H54=\"\",\"\",'Existing b'!H54)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",I308=\"\"),\"\",I308*G$16)","v":""},"UL:",{"$f":"IF('Reference b'!H54=\"\",\"\",'Reference b'!H54)","v":""}]
[null,105,"Pool Maximum Depth to Riffle Mean Depth (dmaxp/dbkf)","Ave:",{"$f":"IF('Existing b'!R54=\"\",\"\",'Existing b'!R54)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(G303=\"N/A\",\"N/A\",G303/G$16)))","v":""},"Ave:",{"$f":"IF('Reference b'!R54=\"\",\"\",'Reference b'!R54)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S54=\"\",\"\",'Existing b'!S54)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G304=\"\"),\"\",G304/G$16)","v":""},"LL:",{"$f":"IF('Reference b'!S54=\"\",\"\",'Reference b'!S54)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T54=\"\",\"\",'Existing b'!T54)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G305=\"\"),\"\",G305/G$16)","v":""},"UL:",{"$f":"IF('Reference b'!T54=\"\",\"\",'Reference b'!T54)","v":""}]
[null,106,"Run Maximum Depth, ft (dmaxr)","Ave:",{"$f":"IF('Existing b'!F52=\"\",\"\",'Existing b'!F52)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(I312=\"N/A\",\"N/A\",I312*G$16)))","v":""},"Ave:",{"$f":"IF('Reference b'!F52=\"\",\"\",'Reference b'!F52)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G52=\"\",\"\",'Existing b'!G52)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",I313=\"\"),\"\",I313*G$16)","v":""},"LL:",{"$f":"IF('Reference b'!G52=\"\",\"\",'Reference b'!G52)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H52=\"\",\"\",'Existing b'!H52)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",I314=\"\"),\"\",I314*G$16)","v":""},"UL:",{"$f":"IF('Reference b'!H52=\"\",\"\",'Reference b'!H52)","v":""}]
[null,107,"Run Maximum Depth to Riffle Mean Depth (dmaxr/dbkf)","Ave:",{"$f":"IF('Existing b'!R52=\"\",\"\",'Existing b'!R52)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(G309=\"N/A\",\"N/A\",G309/G$16)))","v":""},"Ave:",{"$f":"IF('Reference b'!R52=\"\",\"\",'Reference b'!R52)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S52=\"\",\"\",'Existing b'!S52)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G310=\"\"),\"\",G310/G$16)","v":""},"LL:",{"$f":"IF('Reference b'!S52=\"\",\"\",'Reference b'!S52)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T52=\"\",\"\",'Existing b'!T52)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G311=\"\"),\"\",G311/G$16)","v":""},"UL:",{"$f":"IF('Reference b'!T52=\"\",\"\",'Reference b'!T52)","v":""}]
[null,108,"Glide Maximum Depth, ft (dmaxg)","Ave:",{"$f":"IF('Existing b'!F56=\"\",\"\",'Existing b'!F56)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(I318=\"N/A\",\"N/A\",I318*G$16)))","v":""},"Ave:",{"$f":"IF('Reference b'!F56=\"\",\"\",'Reference b'!F56)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G56=\"\",\"\",'Existing b'!G56)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",I319=\"\"),\"\",I319*G$16)","v":""},"LL:",{"$f":"IF('Reference b'!G56=\"\",\"\",'Reference b'!G56)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H56=\"\",\"\",'Existing b'!H56)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",I320=\"\"),\"\",I320*G$16)","v":""},"UL:",{"$f":"IF('Reference b'!H56=\"\",\"\",'Reference b'!H56)","v":""}]
[null,109,"Glide Maximum Depth to Riffle Mean Depth (dmaxg/dbkf)","Ave:",{"$f":"IF('Existing b'!R56=\"\",\"\",'Existing b'!R56)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(G315=\"N/A\",\"N/A\",G315/G$16)))","v":""},"Ave:",{"$f":"IF('Reference b'!R56=\"\",\"\",'Reference b'!R56)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S56=\"\",\"\",'Existing b'!S56)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G316=\"\"),\"\",G316/G$16)","v":""},"LL:",{"$f":"IF('Reference b'!S56=\"\",\"\",'Reference b'!S56)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T56=\"\",\"\",'Existing b'!T56)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G317=\"\"),\"\",G317/G$16)","v":""},"UL:",{"$f":"IF('Reference b'!T56=\"\",\"\",'Reference b'!T56)","v":""}]
[null,110,"Step Maximum Depth, ft (dmaxs)","Ave:",{"$f":"IF('Existing b'!F58=\"\",\"\",'Existing b'!F58)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(I324=\"N/A\",\"N/A\",I324*G$16)))","v":""},"Ave:",{"$f":"IF('Reference b'!F58=\"\",\"\",'Reference b'!F58)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G58=\"\",\"\",'Existing b'!G58)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",I325=\"\"),\"\",I325*G$16)","v":""},"LL:",{"$f":"IF('Reference b'!G58=\"\",\"\",'Reference b'!G58)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H58=\"\",\"\",'Existing b'!H58)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",I326=\"\"),\"\",I326*G$16)","v":""},"UL:",{"$f":"IF('Reference b'!H58=\"\",\"\",'Reference b'!H58)","v":""}]
[null,111,"Step Maximum Depth to Riffle Mean Depth (dmaxs/dbkf)","Ave:",{"$f":"IF('Existing b'!R58=\"\",\"\",'Existing b'!R58)","v":""},"Ave:",{"$f":"IF(G$16=\"\",\"\",(IF(G321=\"N/A\",\"N/A\",G321/G$16)))","v":""},"Ave:",{"$f":"IF('Reference b'!R58=\"\",\"\",'Reference b'!R58)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S58=\"\",\"\",'Existing b'!S58)","v":""},"LL:",{"$f":"IF(OR(G$16=\"\",G322=\"\"),\"\",G322/G$16)","v":""},"LL:",{"$f":"IF('Reference b'!S58=\"\",\"\",'Reference b'!S58)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T58=\"\",\"\",'Existing b'!T58)","v":""},"UL:",{"$f":"IF(OR(G$16=\"\",G323=\"\"),\"\",G323/G$16)","v":""},"UL:",{"$f":"IF('Reference b'!T58=\"\",\"\",'Reference b'!T58)","v":""}]
["Bed Feature Water Surface Facet Slopes and Dimensionless Ratios from Profile",112,"Riffle Slope (water surface facet slope) (Srif)","Ave:",{"$f":"IF('Existing b'!F39=\"\",\"\",'Existing b'!F39)","v":""},"Ave:",{"$f":"IF(F$268=\"\",\"\",(IF(I330=\"N/A\",\"N/A\",I330*F$268)))","v":""},"Ave:",{"$f":"IF('Reference b'!F39=\"\",\"\",'Reference b'!F39)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G39=\"\",\"\",'Existing b'!G39)","v":""},"LL:",{"$f":"IF(OR(F$268=\"\",I331=\"\"),\"\",I331*F$268)","v":""},"LL:",{"$f":"IF('Reference b'!G39=\"\",\"\",'Reference b'!G39)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H39=\"\",\"\",'Existing b'!H39)","v":""},"UL:",{"$f":"IF(OR(F$268=\"\",I332=\"\"),\"\",I332*F$268)","v":""},"UL:",{"$f":"IF('Reference b'!H39=\"\",\"\",'Reference b'!H39)","v":""}]
[null,113,"Riffle Slope to Average Water Surface Slope (Srif/S)","Ave:",{"$f":"IF('Existing b'!R39=\"\",\"\",'Existing b'!R39)","v":""},"Ave:",{"$f":"IF(F$268=\"\",\"\",(IF(G327=\"N/A\",\"N/A\",G327/F$268)))","v":""},"Ave:",{"$f":"IF('Reference b'!R39=\"\",\"\",'Reference b'!R39)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S39=\"\",\"\",'Existing b'!S39)","v":""},"LL:",{"$f":"IF(OR(F$268=\"\",G328=\"\"),\"\",G328/F$268)","v":""},"LL:",{"$f":"IF('Reference b'!S39=\"\",\"\",'Reference b'!S39)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T39=\"\",\"\",'Existing b'!T39)","v":""},"UL:",{"$f":"IF(OR(F$268=\"\",G329=\"\"),\"\",G329/F$268)","v":""},"UL:",{"$f":"IF('Reference b'!T39=\"\",\"\",'Reference b'!T39)","v":""}]
[null,114,"Pool Slope (water surface facet slope) (Sp)","Ave:",{"$f":"IF('Existing b'!F43=\"\",\"\",'Existing b'!F43)","v":""},"Ave:",{"$f":"IF(F$268=\"\",\"\",(IF(I336=\"N/A\",\"N/A\",I336*F$268)))","v":""},"Ave:",{"$f":"IF('Reference b'!F43=\"\",\"\",'Reference b'!F43)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G43=\"\",\"\",'Existing b'!G43)","v":""},"LL:",{"$f":"IF(OR(F$268=\"\",I337=\"\"),\"\",I337*F$268)","v":""},"LL:",{"$f":"IF('Reference b'!G43=\"\",\"\",'Reference b'!G43)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H43=\"\",\"\",'Existing b'!H43)","v":""},"UL:",{"$f":"IF(OR(F$268=\"\",I338=\"\"),\"\",I338*F$268)","v":""},"UL:",{"$f":"IF('Reference b'!H43=\"\",\"\",'Reference b'!H43)","v":""}]
[null,115,"Pool Slope to Average Water Surface Slope (Sp/S)","Ave:",{"$f":"IF('Existing b'!R43=\"\",\"\",'Existing b'!R43)","v":""},"Ave:",{"$f":"IF(F$268=\"\",\"\",(IF(G333=\"N/A\",\"N/A\",G333/F$268)))","v":""},"Ave:",{"$f":"IF('Reference b'!R43=\"\",\"\",'Reference b'!R43)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S43=\"\",\"\",'Existing b'!S43)","v":""},"LL:",{"$f":"IF(OR(F$268=\"\",G334=\"\"),\"\",G334/F$268)","v":""},"LL:",{"$f":"IF('Reference b'!S43=\"\",\"\",'Reference b'!S43)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T43=\"\",\"\",'Existing b'!T43)","v":""},"UL:",{"$f":"IF(OR(F$268=\"\",G335=\"\"),\"\",G335/F$268)","v":""},"UL:",{"$f":"IF('Reference b'!T43=\"\",\"\",'Reference b'!T43)","v":""}]
[null,116,"Run Slope (water surface facet slope) (Srun)","Ave:",{"$f":"IF('Existing b'!F41=\"\",\"\",'Existing b'!F41)","v":""},"Ave:",{"$f":"IF(F$268=\"\",\"\",(IF(I342=\"N/A\",\"N/A\",I342*F$268)))","v":""},"Ave:",{"$f":"IF('Reference b'!F41=\"\",\"\",'Reference b'!F41)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G41=\"\",\"\",'Existing b'!G41)","v":""},"LL:",{"$f":"IF(OR(F$268=\"\",I343=\"\"),\"\",I343*F$268)","v":""},"LL:",{"$f":"IF('Reference b'!G41=\"\",\"\",'Reference b'!G41)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H41=\"\",\"\",'Existing b'!H41)","v":""},"UL:",{"$f":"IF(OR(F$268=\"\",I344=\"\"),\"\",I344*F$268)","v":""},"UL:",{"$f":"IF('Reference b'!H41=\"\",\"\",'Reference b'!H41)","v":""}]
[null,117,"Run Slope to Average Water Surface Slope (Srun/S)","Ave:",{"$f":"IF('Existing b'!R41=\"\",\"\",'Existing b'!R41)","v":""},"Ave:",{"$f":"IF(F$268=\"\",\"\",(IF(G339=\"N/A\",\"N/A\",G339/F$268)))","v":""},"Ave:",{"$f":"IF('Reference b'!R41=\"\",\"\",'Reference b'!R41)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S41=\"\",\"\",'Existing b'!S41)","v":""},"LL:",{"$f":"IF(OR(F$268=\"\",G340=\"\"),\"\",G340/F$268)","v":""},"LL:",{"$f":"IF('Reference b'!S41=\"\",\"\",'Reference b'!S41)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T41=\"\",\"\",'Existing b'!T41)","v":""},"UL:",{"$f":"IF(OR(F$268=\"\",G341=\"\"),\"\",G341/F$268)","v":""},"UL:",{"$f":"IF('Reference b'!T41=\"\",\"\",'Reference b'!T41)","v":""}]
[null,118,"Glide Slope (water surface facet slope) (Sg)","Ave:",{"$f":"IF('Existing b'!F45=\"\",\"\",'Existing b'!F45)","v":""},"Ave:",{"$f":"IF(F$268=\"\",\"\",(IF(I348=\"N/A\",\"N/A\",I348*F$268)))","v":""},"Ave:",{"$f":"IF('Reference b'!F45=\"\",\"\",'Reference b'!F45)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G45=\"\",\"\",'Existing b'!G45)","v":""},"LL:",{"$f":"IF(OR(F$268=\"\",I349=\"\"),\"\",I349*F$268)","v":""},"LL:",{"$f":"IF('Reference b'!G45=\"\",\"\",'Reference b'!G45)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H45=\"\",\"\",'Existing b'!H45)","v":""},"UL:",{"$f":"IF(OR(F$268=\"\",I350=\"\"),\"\",I350*F$268)","v":""},"UL:",{"$f":"IF('Reference b'!H45=\"\",\"\",'Reference b'!H45)","v":""}]
[null,119,"Glide Slope to Average Water Surface Slope (Sg/S)","Ave:",{"$f":"IF('Existing b'!R45=\"\",\"\",'Existing b'!R45)","v":""},"Ave:",{"$f":"IF(F$268=\"\",\"\",(IF(G345=\"N/A\",\"N/A\",G345/F$268)))","v":""},"Ave:",{"$f":"IF('Reference b'!R45=\"\",\"\",'Reference b'!R45)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S45=\"\",\"\",'Existing b'!S45)","v":""},"LL:",{"$f":"IF(OR(F$268=\"\",G346=\"\"),\"\",G346/F$268)","v":""},"LL:",{"$f":"IF('Reference b'!S45=\"\",\"\",'Reference b'!S45)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T45=\"\",\"\",'Existing b'!T45)","v":""},"UL:",{"$f":"IF(OR(F$268=\"\",G347=\"\"),\"\",G347/F$268)","v":""},"UL:",{"$f":"IF('Reference b'!T45=\"\",\"\",'Reference b'!T45)","v":""}]
[null,120,"Step Slope (water surface facet slope) (Ss)","Ave:",{"$f":"IF('Existing b'!F47=\"\",\"\",'Existing b'!F47)","v":""},"Ave:",{"$f":"IF(F$268=\"\",\"\",(IF(I354=\"N/A\",\"N/A\",I354*F$268)))","v":""},"Ave:",{"$f":"IF('Reference b'!F47=\"\",\"\",'Reference b'!F47)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!G47=\"\",\"\",'Existing b'!G47)","v":""},"LL:",{"$f":"IF(OR(F$268=\"\",I355=\"\"),\"\",I355*F$268)","v":""},"LL:",{"$f":"IF('Reference b'!G47=\"\",\"\",'Reference b'!G47)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!H47=\"\",\"\",'Existing b'!H47)","v":""},"UL:",{"$f":"IF(OR(F$268=\"\",I356=\"\"),\"\",I356*F$268)","v":""},"UL:",{"$f":"IF('Reference b'!H47=\"\",\"\",'Reference b'!H47)","v":""}]
[null,121,"Step Slope to Average Water Surface Slope (Ss/S)","Ave:",{"$f":"IF('Existing b'!R47=\"\",\"\",'Existing b'!R47)","v":""},"Ave:",{"$f":"IF(F$268=\"\",\"\",(IF(G351=\"N/A\",\"N/A\",G351/F$268)))","v":""},"Ave:",{"$f":"IF('Reference b'!R47=\"\",\"\",'Reference b'!R47)","v":""}]
[null,null,null,"LL:",{"$f":"IF('Existing b'!S47=\"\",\"\",'Existing b'!S47)","v":""},"LL:",{"$f":"IF(OR(F$268=\"\",G352=\"\"),\"\",G352/F$268)","v":""},"LL:",{"$f":"IF('Reference b'!S47=\"\",\"\",'Reference b'!S47)","v":""}]
[null,null,null,"UL:",{"$f":"IF('Existing b'!T47=\"\",\"\",'Existing b'!T47)","v":""},"UL:",{"$f":"IF(OR(F$268=\"\",G353=\"\"),\"\",G353/F$268)","v":""},"UL:",{"$f":"IF('Reference b'!T47=\"\",\"\",'Reference b'!T47)","v":""}]
["Channel Materials",122,"Particle Size Distribution of Reach-wide Channel Materials"]
[null,null,"D16 (mm)",{"$f":"IF('Existing b'!M63=\"\",\"\",'Existing b'!M63)","v":""},null,{"$f":"D358","v":""},null,{"$f":"IF('Reference b'!M63=\"\",\"\",'Reference b'!M63)","v":""}]
[null,null,"D35 (mm)",{"$f":"IF('Existing b'!O65=\"\",\"\",'Existing b'!O65)","v":""},null,"",null,{"$f":"IF('Reference b'!M65=\"\",\"\",'Reference b'!M65)","v":""}]
[null,null,"D50 (mm)",{"$f":"IF('Existing b'!M67=\"\",\"\",'Existing b'!M67)","v":""},null,"",null,{"$f":"IF('Reference b'!M67=\"\",\"\",'Reference b'!M67)","v":""}]
[null,null,"D84 (mm)",{"$f":"IF('Existing b'!M69=\"\",\"\",'Existing b'!M69)","v":""},null,"",null,{"$f":"IF('Reference b'!M69=\"\",\"\",'Reference b'!M69)","v":""}]
[null,null,"D95 (mm)",{"$f":"IF('Existing b'!M71=\"\",\"\",'Existing b'!M71)","v":""},null,"",null,{"$f":"IF('Reference b'!M71=\"\",\"\",'Reference b'!M71)","v":""}]
[null,null,"D100 (mm)",{"$f":"IF('Existing b'!M73=\"\",\"\",'Existing b'!M73)","v":""},null,"",null,{"$f":"IF('Reference b'!M73=\"\",\"\",'Reference b'!M73)","v":""}]
[null,123,"Particle Size Distribution of Active Bed or Pavement Channel Materials"]
[null,null,"D16 (mm)",{"$f":"IF('Existing b'!O63=\"\",\"\",'Existing b'!O63)","v":""},null,{"$f":"D365","v":""},null,{"$f":"IF('Reference b'!O63=\"\",\"\",'Reference b'!O63)","v":""}]
[null,null,"D35 (mm)",{"$f":"IF('Existing b'!O65=\"\",\"\",'Existing b'!O65)","v":""},null,"",null,{"$f":"IF('Reference b'!O65=\"\",\"\",'Reference b'!O65)","v":""}]
[null,null,"D50 (mm)",{"$f":"IF('Existing b'!O67=\"\",\"\",'Existing b'!O67)","v":""},null,"",null,{"$f":"IF('Reference b'!O67=\"\",\"\",'Reference b'!O67)","v":""}]
[null,null,"D84 (mm)",{"$f":"IF('Existing b'!O69=\"\",\"\",'Existing b'!O69)","v":""},null,"",null,{"$f":"IF('Reference b'!O69=\"\",\"\",'Reference b'!O69)","v":""}]
[null,null,"D95 (mm)",{"$f":"IF('Existing b'!O71=\"\",\"\",'Existing b'!O71)","v":""},null,"",null,{"$f":"IF('Reference b'!O71=\"\",\"\",'Reference b'!O71)","v":""}]
[null,null,"D100 (mm)",{"$f":"IF('Existing b'!O73=\"\",\"\",'Existing b'!O73)","v":""},null,"",null,{"$f":"IF('Reference b'!O73=\"\",\"\",'Reference b'!O73)","v":""}]
[null,124,"Particle Size Distribution of Bar Material or Sub-pavement"]
[null,null,"D16 (mm)",{"$f":"IF('Existing b'!Q63=\"\",\"\",'Existing b'!Q63)","v":""},null,{"$f":"D372","v":""},null,{"$f":"IF('Reference b'!Q63=\"\",\"\",'Reference b'!Q63)","v":""}]
[null,null,"D35 (mm)",{"$f":"IF('Existing b'!Q65=\"\",\"\",'Existing b'!Q65)","v":""},null,"",null,{"$f":"IF('Reference b'!Q65=\"\",\"\",'Reference b'!Q65)","v":""}]
[null,null,"D50 (mm)",{"$f":"IF('Existing b'!Q67=\"\",\"\",'Existing b'!Q67)","v":""},null,"",null,{"$f":"IF('Reference b'!Q67=\"\",\"\",'Reference b'!Q67)","v":""}]
[null,null,"D84 (mm)",{"$f":"IF('Existing b'!Q69=\"\",\"\",'Existing b'!Q69)","v":""},null,"",null,{"$f":"IF('Reference b'!Q69=\"\",\"\",'Reference b'!Q69)","v":""}]
[null,null,"D95 (mm)",{"$f":"IF('Existing b'!Q71=\"\",\"\",'Existing b'!Q71)","v":""},null,"",null,{"$f":"IF('Reference b'!Q71=\"\",\"\",'Reference b'!Q71)","v":""}]
[null,null,"Dmax (mm)",{"$f":"IF('Existing b'!Q73=\"\",\"\",'Existing b'!Q73)","v":""},null,"",null,{"$f":"IF('Reference b'!Q73=\"\",\"\",'Reference b'!Q73)","v":""}]
["Hydraulics & Flood Capacity",125,"Estimated Bankfull Mean Velocity, ft/sec (ūbkf)",{"$f":"IF('Existing b'!L6=\"\",\"\",'Existing b'!L6)","v":""},null,null,null,{"$f":"IF('Reference b'!L6=\"\",\"\",'Reference b'!L6)","v":""}]
[]
[null,126,"Estimated Bankfull Discharge, cfs (Qbkf); Compare with Regional Curve",{"$f":"IF('Existing b'!L8=\"\",\"\",'Existing b'!L8)","v":""},null,null,null,{"$f":"IF('Reference b'!L8=\"\",\"\",'Reference b'!L8)","v":""}]
[]
[null,127,"Floodplain Capacity: Discharge (Qfp)"]
[]
[null,128,"Floodplain Capacity:  Cross-Sectional Area (Afp)"]
[]
[null,129,"Low Terrace Capacity: Discharge (Qlt)"]
[]
[null,130,"Low Terrace Capacity:  Cross-Sectional Area (Alt)"]
[]
[null,131,"Flood-Prone Area Capacity: Discharge (Qfpa)"]
[]
[null,132,"Flood-Prone Area Capacity:  Cross-Sectional Area (Afpa)"]
[]
["Sediment Competence",133,"Calculated bankfull shear stress value, lbs/ft2 (t)",{"$f":"IF('Existing Competence'!B25=\"\",\"\",'Existing Competence'!B25)","v":""},null,{"$f":"IF('Proposed Competence'!B25=\"\",\"\",'Proposed Competence'!B25)","v":""},null,{"$f":"IF('Reference Competence'!B25=\"\",\"\",'Reference Competence'!B25)","v":""}]
[null,134,"Predicted largest moveable particle size (mm) at bankfull shear stress, (t)","Shields:",{"$f":"IF('Existing Competence'!B27=\"\",\"\",'Existing Competence'!B27)","v":""},"Shields:",{"$f":"IF('Proposed Competence'!B27=\"\",\"\",'Proposed Competence'!B27)","v":""},"Shields:",{"$f":"IF('Reference Competence'!B27=\"\",\"\",'Reference Competence'!B27)","v":""}]
[null,null,null,"Rosgen:",{"$f":"IF('Existing Competence'!C27=\"\",\"\",'Existing Competence'!C27)","v":""},"Rosgen:",{"$f":"IF('Proposed Competence'!C27=\"\",\"\",'Proposed Competence'!C27)","v":""},"Rosgen:",{"$f":"IF('Reference Competence'!C27=\"\",\"\",'Reference Competence'!C27)","v":""}]
[null,135,"Largest particle size to be moved (Dmax) (mm) (see #124: Particle Size Distribution of Bar Material)",{"$f":"IF('Existing Competence'!I8=\"\",\"\",'Existing Competence'!I8)","v":""},null,{"$f":"IF('Proposed Competence'!I8=\"\",\"\",'Proposed Competence'!I8)","v":""},null,{"$f":"IF('Reference Competence'!I8=\"\",\"\",'Reference Competence'!I8)","v":""}]
[null,136,"Predicted shear stress required to initiate movement of Dmax (mm)","Shields:",{"$f":"IF('Existing Competence'!B29=\"\",\"\",'Existing Competence'!B29)","v":""},"Shields:",{"$f":"IF('Proposed Competence'!B29=\"\",\"\",'Proposed Competence'!B29)","v":""},"Shields:",{"$f":"IF('Reference Competence'!B29=\"\",\"\",'Reference Competence'!B29)","v":""}]
[null,null,null,"Rosgen:",{"$f":"IF('Existing Competence'!C29=\"\",\"\",'Existing Competence'!C29)","v":""},"Rosgen:",{"$f":"IF('Proposed Competence'!C29=\"\",\"\",'Proposed Competence'!C29)","v":""},"Rosgen:",{"$f":"IF('Reference Competence'!C29=\"\",\"\",'Reference Competence'!C29)","v":""}]
[null,137,"Predicted mean depth required to initiate movement of Dmax (mm), d = t/gS (t = predicted shear stress, g = 62.4, S = existing or design slope)","Shields:",{"$f":"IF('Existing Competence'!B31=\"\",\"\",'Existing Competence'!B31)","v":""},"Shields:",{"$f":"IF('Proposed Competence'!B31=\"\",\"\",'Proposed Competence'!B31)","v":""},"Shields:",{"$f":"IF('Reference Competence'!B31=\"\",\"\",'Reference Competence'!B31)","v":""}]
[null,null,null,"Rosgen:",{"$f":"IF('Existing Competence'!B31=\"\",\"\",'Existing Competence'!B31)","v":""},"Rosgen:",{"$f":"IF('Proposed Competence'!C31=\"\",\"\",'Proposed Competence'!C31)","v":""},"Rosgen:",{"$f":"IF('Reference Competence'!B31=\"\",\"\",'Reference Competence'!B31)","v":""}]
[null,138,"Predicted slope required to initiate movement of Dmax (mm) S=t/gd (t = predicted shear stress, g = 62.4, d = existing or design depth)","Shields:",{"$f":"IF('Existing Competence'!B33=\"\",\"\",'Existing Competence'!B33)","v":""},"Shields:",{"$f":"IF('Proposed Competence'!B33=\"\",\"\",'Proposed Competence'!B33)","v":""},"Shields:",{"$f":"IF('Reference Competence'!B33=\"\",\"\",'Reference Competence'!B33)","v":""}]
[null,null,null,"Rosgen:",{"$f":"IF('Existing Competence'!C33=\"\",\"\",'Existing Competence'!C33)","v":""},"Rosgen:",{"$f":"IF('Proposed Competence'!C33=\"\",\"\",'Proposed Competence'!C33)","v":""},"Rosgen:",{"$f":"IF('Reference Competence'!C33=\"\",\"\",'Reference Competence'!C33)","v":""}]
[null,139,"Bankfull dimensionless shear stress (t*)",{"$f":"IF('Existing Competence'!B16=\"\",\"\",'Existing Competence'!B16)","v":""},null,{"$f":"IF('Proposed Competence'!B16=\"\",\"\",'Proposed Competence'!B16)","v":""},null,{"$f":"IF('Reference Competence'!B16=\"\",\"\",'Reference Competence'!B16)","v":""}]
[null,140,"Required bankfull mean depth dbkf (ft) using dimensionless shear stress equation: dbkf = t*(gs - 1)Dmax/S   (Note: Dmax in ft)",{"$f":"IF('Existing Competence'!B19=\"\",\"\",'Existing Competence'!B19)","v":""},null,{"$f":"IF('Proposed Competence'!B19=\"\",\"\",'Proposed Competence'!B19)","v":""},null,{"$f":"IF('Reference Competence'!B19=\"\",\"\",'Reference Competence'!B19)","v":""}]
[null,141,"Required bankfull water surface slope S (ft) using dimensionless shear stress equation: S = t*(gs - 1)Dmax/dbkf    (Note: Dmax in ft)",{"$f":"IF('Existing Competence'!B21=\"\",\"\",'Existing Competence'!B21)","v":""},null,{"$f":"IF('Proposed Competence'!B21=\"\",\"\",'Proposed Competence'!B21)","v":""},null,{"$f":"IF('Reference Competence'!B21=\"\",\"\",'Reference Competence'!B21)","v":""}]
["Sediment Yield","Sediment Yield (FLOWSED)",null,"Existing Reach",null,"Proposed Design Reach",null,"Difference in Sediment Yield"]
[null,142,"Bedload Sediment Yield (tons/yr)",null,null,null,null,{"$f":"IF(OR(D408=\"\",F408=\"\"),\"\",D408-F408)","v":""}]
[null,143,"Suspended Sediment Yield (tons/yr)",null,null,null,null,{"$f":"IF(OR(D409=\"\",F409=\"\"),\"\",D409-F409)","v":""}]
[null,144,"Suspended Sand Sediment Yield (tons/yr)",null,null,null,null,""]
[null,145,"Total Annual Sediment Yield (tons/yr)",null,null,null,null,""]
["Sediment Transport","Sediment Yield (POWERSED)",null,"Existing Reach",null,"Proposed Design Reach",null,"Difference in Sed. Transport"]
[null,146,"Bedload Sediment Transport (tons/yr)",null,null,null,null,{"$f":"IF(OR(D413=\"\",F413=\"\"),\"\",D413-F413)","v":""}]
[null,147,"Suspended Sediment Transport (tons/yr)",null,null,null,null,{"$f":"IF(OR(D414=\"\",F414=\"\"),\"\",D414-F414)","v":""}]
[null,148,"Suspended Sand Sediment Transport (tons/yr)",null,null,null,null,""]
[null,149,"Total Annual Sediment Transport (tons/yr)",null,null,null,null,""]
["Streambank Erosion","Streambank Erosion ",null,"Existing Reach",null,"Proposed Design Reach",null,"Reference Reach"]
[null,150,"Stream Length Assessed (ft)",{"$f":"IF('Existing Bank Erosion'!G2=\"\",\"\",'Existing Bank Erosion'!G2)","v":""},null,{"$f":"IF(F259=\"\",\"\",F259)","v":""},null,{"$f":"IF('Reference Bank Erosion'!G2=\"\",\"\",'Reference Bank Erosion'!G2)","v":""}]
[null,151,"Graph/Curve Used (e.g., Yellowstone or Colorado)",{"$f":"IF('Existing Bank Erosion'!C2=\"\",\"\",'Existing Bank Erosion'!C2)","v":""},null,{"$f":"IF(D419=\"\",\"\",D419)","v":""},null,{"$f":"IF('Reference Bank Erosion'!C2=\"\",\"\",'Reference Bank Erosion'!C2)","v":""}]
[null,152,"Streambank Erosion (tons/yr)",{"$f":"IF('Existing Bank Erosion'!I23=\"\",\"\",'Existing Bank Erosion'!I23)","v":""},null,{"$f":"IF(OR(H421=\"\",F418=\"\"),\"\",F418*H421)","v":""},null,{"$f":"IF('Reference Bank Erosion'!I23=\"\",\"\",'Reference Bank Erosion'!I23)","v":""}]
[null,153,"Streambank Erosion Rate (tons/yr/ft)",{"$f":"IF('Existing Bank Erosion'!I24=\"\",\"\",'Existing Bank Erosion'!I24)","v":""},null,{"$f":"IF(H421=\"\",\"\",H421)","v":""},null,{"$f":"IF('Reference Bank Erosion'!I24=\"\",\"\",'Reference Bank Erosion'!I24)","v":""}]

{"sheet":"Proposed Velocity","index":2,"n_rows":61,"n_cols":28,"rows_kept":61,"cut":false,"hidden":false,"merged":[[52,1,52,10],[58,19,60,25],[48,1,48,10],[48,12,50,12],[48,13,50,13],[48,15,50,15],[48,16,50,16],[49,2,49,5],[44,1,44,10],[44,12,46,12],[44,13,46,13],[44,15,46,15],[44,16,46,16],[45,2,45,9],[40,1,40,10],[40,12,42,12],[40,13,42,13],[40,15,42,15],[40,16,42,16],[41,2,41,9],[35,16,36,16],[36,7,36,9],[31,1,31,4],[31,7,31,9],[31,12,33,12],[31,13,33,13],[31,15,33,15],[31,16,33,16],[35,1,35,4],[35,7,35,9],[35,12,36,12],[35,13,36,13],[35,15,36,15],[23,15,23,16],[25,1,25,10],[27,1,27,10],[27,12,29,12],[27,13,29,13],[27,15,29,15],[27,16,29,16],[19,1,19,4],[19,9,19,13],[21,1,21,4],[21,9,21,13],[23,1,23,10],[23,12,23,13],[13,1,13,4],[13,9,13,13],[15,1,15,4],[15,9,15,13],[17,1,17,4],[17,9,17,13],[7,1,7,2],[7,3,7,7],[9,1,9,7],[9,9,9,16],[11,1,11,4],[11,9,11,13],[5,1,5,2],[5,4,5,6],[5,9,5,12],[5,13,5,16],[1,19,5,23],[1,1,1,16],[3,1,3,2],[3,3,3,7],[3,9,3,11],[3,12,3,16]]}
[]
[null,"Bankfull VELOCITY & DISCHARGE Estimates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Numerous cells contain formulas and therefore the cells are locked; to unlock cells, unprotect sheet under \"Tools\" & \"Protection\" (2003) or \"File\" & \"Permissions\" (2007/2010)"]
[]
[null," Stream:",null,null,null,null,null,null,null,"Location:"]
[]
[null," Date:",null,null,"Stream Type:",null,null,{"$f":"IF('Design Table'!F10=\"\",\"\",'Design Table'!F10)","v":""},null,"Valley Type:",null,null,null,{"$f":"IF('Design Table'!F8=\"\",\"\",'Design Table'!F8)","v":""}]
[]
[null," Observers:",null,null,null,null,null,null,null," HUC:"]
[]
[null,"Input Variables for PROPOSED Design",null,null,null,null,null,null,null,"Output Variables for PROPOSED Design"]
[]
[null,"Bankfull Riffle Cross-Sectional AREA",null,null,null,null,{"$f":"IF('Design Table'!G22=\"\",\"\",'Design Table'!G22)","v":""},"Abkf               (ft2)",null,"Bankfull Riffle Mean DEPTH",null,null,null,null,null,{"$f":"IF(OR(G12=\"\",G14=\"\"),\"\",G12/G14)","v":""},"dbkf          (ft)"]
[]
[null,"Bankfull Riffle WIDTH",null,null,null,null,{"$f":"IF('Design Table'!G13=\"\",\"\",'Design Table'!G13)","v":""},"Wbkf          (ft)",null,"Wetted PERIMETER              ~ (2 * dbkf ) + Wbkf",null,null,null,null,null,{"$f":"IF(OR(P12=\"\",G14=\"\"),\"\",2*P12+G14)","v":""},"Wp          (ft)"]
[]
[null,"D84 at Riffle",null,null,null,null,{"$f":"IF('Design Table'!F368=\"\",\"\",'Design Table'!F368)","v":""},"Dia.         (mm)",null,"D84 (mm) / 304.8",null,null,null,null,null,{"$f":"IF(OR(G16=\"\"),\"\",G16/304.8)","v":""},"D84          (ft)"]
[]
[null,"Bankfull SLOPE",null,null,null,null,{"$f":"IF('Design Table'!F268=\"\",\"\",'Design Table'!F268)","v":""},"Sbkf          (ft / ft)",null,"Hydraulic RADIUS                 Abkf / Wp",null,null,null,null,null,{"$f":"IF(OR(G12=\"\",P14=\"\"),\"\",G12/P14)","v":""},"R          (ft)"]
[]
[null,"Gravitational Acceleration",null,null,null,null,32.200000000000003,"g                 (ft / sec2)",null,"Relative Roughness               R(ft) / D84 (ft)",null,null,null,null,null,{"$f":"IF(OR(P18=\"\",P16=\"\"),\"\",P18/P16)","v":""},"R / D84"]
[]
[null,"Drainage Area",null,null,null,null,{"$f":"IF('Design Table'!F11=\"\",\"\",'Design Table'!F11)","v":""},"DA          (mi2)",null,"Shear Velocity                          u* = (gRS)½",null,null,null,null,null,{"$f":"IF(OR(G20=\"\",P18=\"\",G18=\"\"),\"\",(G20*P18*G18)^0.5)","v":""},"u*          (ft/sec)"]
[]
[null,"ESTIMATION METHODS",null,null,null,null,null,null,null,null,null,null,"Bankfull   VELOCITY",null,null,"Bankfull DISCHARGE"]
[]
[null,"ū = [ 2.83 + 5.66 * Log { R / D84 } ] u*  ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(P20=\"\",P22=\"\"),\"\",(2.83+5.66*LOG(P20))*P22)","v":""},"ft / sec",null,{"$f":"IF(OR(M26=\"\",G$12=\"\",G18=\"\"),\"\",M26*G$12)","v":""},"cfs",null,null,null,null,null,null,null,null,null,null,"Figure 4-45.  Friction factor (u/u*) vs. Manning's roughness coefficient n (Rosgen, 2006b; Rosgen and Silvey, 2007)."]
[]
[null," 2. Roughness Coefficient:  a) Manning's n from Friction Factor / Relative ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(P18=\"\",G18=\"\",J29=\"\"),\"\",1.49*P18^(2/3)*G18^0.5/J29)","v":""},"ft / sec",null,{"$f":"IF(OR(M28=\"\",G$12=\"\"),\"\",M28*G$12)","v":""},"cfs"]
[null,null,"Roughness (Figs. 4-44, 4-45) ",null,null,null,null,"ū = 1.49*R2/3*S1/2/ n    n ="]
[]
[]
[null," 2. Roughness Coefficient:  ",null,null,null,null,null,"ū = 1.49*R2/3*S1/2/ n",null,null,null,null,{"$f":"IF(OR(P18=\"\",G18=\"\",J33=\"\"),\"\",1.49*P18^(2/3)*G18^0.5/J33)","v":""},"ft / sec",null,{"$f":"IF(OR(M32=\"\",G$12=\"\"),\"\",M32*G$12)","v":""},"cfs"]
[null,null," b) Manning's n from Stream Type (Fig. 4-46)              ",null,null,null,null,"n ="]
[]
[]
[null," 2. Roughness Coefficient:  ",null,null,null,null,null,"ū = 1.49*R2/3*S1/2/ n",null,null,null,null,{"$f":"IF(OR(P18=\"\",G18=\"\",J38=\"\"),\"\",1.49*P18^(2/3)*G18^0.5/J38)","v":""},"ft / sec",null,{"$f":"IF(OR(M36=\"\",G$12=\"\"),\"\",M36*G$12)","v":""},"cfs"]
[null,null," c) Manning's n from Jarrett (USGS):               ",null,null,null,null,"n = 0.39*S0.38*R-0.16"]
[null,null,null,null,null,null,null,"n =",null,{"$f":"IF(OR(G18=\"\",P18=\"\"),\"\",0.39*G18^0.38*P18^-0.16)","v":""}]
[]
[]
[null," 3. Other Methods (Hey, Darcy-Weisbach, Chezy C, etc.)",null,null,null,null,null,null,null,null,null,null,null,"ft / sec",null,{"$f":"IF(OR(M41=\"\",G$12=\"\"),\"\",M41*G$12)","v":""},"cfs"]
[]
[]
[]
[null," 3. Other Methods (Hey, Darcy-Weisbach, Chezy C, etc.)",null,null,null,null,null,null,null,null,null,null,null,"ft / sec",null,{"$f":"IF(OR(M45=\"\",G$12=\"\"),\"\",M45*G$12)","v":""},"cfs"]
[]
[]
[]
[null," 4. Continuity Equations:       a) USGS Gage Data       ū = Q / A",null,null,null,null,null,null,null,null,null,null,null,"ft / sec",null,{"$f":"IF(OR(M49=\"\",G$12=\"\"),\"\",M49*G$12)","v":""},"cfs"]
[null,null,"Return Period for Bankfull Q",null,null,null,"Q = ",null,null," year"]
[]
[]
[null," 4. Continuity Equations:       b) Regional Curves       ū = Q / A",null,null,null,null,null,null,null,null,null,null,null,"ft / sec",null,{"$f":"IF(OR(M53=\"\",G$12=\"\"),\"\",M53*G$12)","v":""},"cfs"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 4-44.  Relative roughness (R/D84) vs. friction factor (u/u*) Rosgen, 2006b; Rosgen and Silvey, 2007)."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 4-46.  Manning's n by stream type (Rosgen and Silvey, 2007)."]

{"sheet":"Proposed Competence","index":3,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,13,3,18],[32,13,33,21],[25,3,26,10],[27,3,28,10],[29,3,30,10],[31,3,32,10],[33,6,33,7],[1,3,1,6],[1,7,1,8],[1,9,1,10],[2,3,2,6],[2,7,2,8],[2,9,2,10],[3,3,3,6],[3,9,3,10],[4,1,4,10],[24,1,24,2],[24,3,24,10],[12,1,12,10],[14,1,14,2],[15,1,15,2],[15,8,15,9],[17,1,17,10],[18,1,18,2],[19,1,19,10],[20,1,20,2],[21,6,21,7],[23,1,23,10],[5,1,5,2],[5,4,5,10],[6,1,6,2],[6,4,6,10],[13,1,13,2],[10,1,10,2],[10,4,10,10],[8,1,8,2],[8,4,8,10],[9,1,9,2],[9,4,9,10],[7,1,7,2],[7,4,7,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Numerous cells contain formulas and therefore the cells are locked; to unlock cells, unprotect sheet under \"Tools\" & \"Protection\" (2003) or \"File\" & \"Permissions\" (2007/2010)"]
[null,"Stream:  ",null,null,null,null,null,"Stream Type:",null,{"$f":"IF('Design Table'!F10=\"\",\"\",'Design Table'!F10)","v":""}]
[null,"Location:  ",null,null,null,null,null,"Valley Type:",null,{"$f":"IF('Design Table'!F8=\"\",\"\",'Design Table'!F8)","v":""}]
[null,"Observers:",null,null,null,null,null,null,"Date:"]
[null,"Enter Required Information for PROPOSED Design Condition"]
[null,{"$f":"IF('Design Table'!F367=\"\",\"\",'Design Table'!F367)","v":""},null,"D50","Median particle size of riffle bed material (mm)"]
[null,{"$f":"IF('Design Table'!F374=\"\",\"\",'Design Table'!F374)","v":""},null,"D50","Median particle size of bar or sub-pavement sample (mm)"]
[null,{"$f":"IF(I8=\"\",\"\",I8/304.8)","v":""},null,"Dmax","Largest particle from bar sample (ft)",null,null,null,{"$f":"IF('Design Table'!F377=\"\",\"\",'Design Table'!F377)","v":""},"(mm)","304.8 mm/ft"]
[null,{"$f":"IF('Design Table'!F268=\"\",\"\",'Design Table'!F268)","v":""},null,"S","Proposed design bankfull water surface slope (ft/ft)"]
[null,{"$f":"IF('Design Table'!G16=\"\",\"\",'Design Table'!G16)","v":""},null,"d","Proposed design bankfull mean depth (ft)"]
[null,1.65,null,"gs-g/g","Immersed specific gravity of sediment"]
[]
[null,"Select the Appropriate Equation and Calculate Critical Dimensionless Shear Stress"]
[null,{"$f":"IF(OR(B6=\"\",B7=\"\"),\"\",B6/B7)","v":""},null,null,"Range:  3 – 7",null," Use EQUATION 1:",null,"t* = 0.0834 (                ) –0.872"]
[null,{"$f":"IF(OR(I8=\"\",B6=\"\"),\"\",I8/B6)","v":""},null,"Dmax/D50 ","Range:  1.3 – 3.0",null," Use EQUATION 2:",null,"t* = 0.0384 (Dmax/D50) –0.887"]
[null,{"$f":"IF(OR(B14=\"\",B15=\"\"),\"\",IF(AND(B14>2.9999,B14<7.01),0.0834*B14^(-0.872),IF(AND(B15>1.2999,B15<3.01),0.0384*B15^(-0.887),\"N/A\")))","v":""},null,"t*","Bankfull Dimensionless Shear Stress",null,null,null,"EQUATION USED:",null,{"$f":"IF(B16=\"\",\"\",IF(B16=0.0834*B14^(-0.872),\"1\",IF(B16=0.0384*B15^(-0.887),\"2\",IF(B16=\"N/A\",\"N/A\",\"\"))))","v":""}]
[]
[null,"Calculate Bankfull Mean Depth Required for Entrainment of Largest Particle in Bar Sample"]
[null,{"$f":"IF(OR(B8=\"\",B9=\"\",B16=\"\"),\"\",IF(B16=\"N/A\",\"N/A\",B16*B11*B8/B9))","v":""},null,"d","Required bankfull mean depth (ft)                                            ",null,null,null,null,null," (use Dmax in ft)"]
[null,"Calculate Bankfull Water Surface Slope Required for Entrainment of Largest Particle in Bar Sample"]
[null,{"$f":"IF(OR(B16=\"\",B8=\"\",B10=\"\"),\"\",IF(B16=\"N/A\",\"N/A\",B16*B11*B8/B10))","v":""},null,"S","Required bankfull water surface slope (ft/ft)",null,null,null,null,null,"(use Dmax in ft)"]
[null,null,null,"Check:","Stable ","Aggrading ","Degrading "]
[]
[null,"Sediment Competence Using Dimensional Shear Stress"]
[null,{"$f":"IF(OR(B10=\"\",B9=\"\"),\"\",62.4*B10*B9)","v":""},null,"Bankfull shear stress t = gdS (lbs/ft2) (substitute hydraulic radius, R, with mean depth, d )                             g = 62.4, d = proposed design depth, S = proposed design slope"]
[null,"Shields","Rosgen","Predicted largest moveable particle size (mm) at bankfull shear stress t (Figure 5-49)"]
[null,{"$f":"IF(B25=\"\",\"\",77.966*B25^1.042)","v":""},{"$f":"IF(B25=\"\",\"\",152.02*B25^0.7355)","v":""}]
[null,"Shields","Rosgen","Predicted shear stress required to initiate movement of measured Dmax (mm) (Figure 5-49)"]
[null,{"$f":"IF(OR(B25=\"\",I8=\"\"),\"\",(I8/77.966)^(1/1.042))","v":""},{"$f":"IF(OR(B25=\"\",I8=\"\"),\"\",(I8/152.02)^(1/0.7355))","v":""}]
[null,"Shields","Rosgen","Predicted mean depth required to initiate movement of measured Dmax (mm)                                                     t = predicted shear stress, g = 62.4, S = proposed design slope"]
[null,{"$f":"IF(OR(B29=\"\",B9=\"\"),\"\",B29/(62.4*B9))","v":""},{"$f":"IF(OR(C29=\"\",B9=\"\"),\"\",C29/(62.4*B9))","v":""}]
[null,"Shields","Rosgen","Predicted slope required to initiate movement of measured Dmax (mm)                                                t = predicted shear stress, g = 62.4, d = proposed design depth"]
[null,{"$f":"IF(OR(B29=\"\",B10=\"\"),\"\",B29/(62.4*B10))","v":""},{"$f":"IF(OR(C29=\"\",B10=\"\"),\"\",C29/(62.4*B10))","v":""},null,null,null,null,null,null,null,null,null,null,"Figure 5-49.  Critical shear stress required to initiate movement of bed-material grains following the Shields relation (Leopold et al., 1964), as modified by field data from Rosgen (Rosgen, 2006b)."]
[null,null,null,"Check:","Stable ","Aggrading ","Degrading "]

{"sheet":"Existing a","index":4,"n_rows":88,"n_cols":35,"rows_kept":88,"cut":false,"hidden":false,"merged":[[76,30,82,37],[1,22,6,26],[63,30,67,37],[68,29,69,29],[68,30,73,37],[74,28,74,33],[74,34,74,37],[57,30,57,33],[57,34,57,37],[59,30,59,33],[59,34,59,37],[61,30,61,33],[61,34,61,37],[50,30,50,33],[50,34,50,37],[52,30,54,33],[52,34,54,37],[55,30,55,33],[42,30,42,37],[44,30,44,37],[46,30,46,33],[46,34,46,37],[48,30,48,33],[48,34,48,37],[27,30,27,33],[27,34,27,37],[29,30,31,37],[35,28,35,31],[37,30,41,37],[20,30,22,33],[20,34,22,37],[23,30,23,33],[23,34,23,37],[25,30,25,33],[25,34,25,37],[14,30,14,33],[14,34,14,37],[16,30,16,33],[16,34,16,37],[18,30,18,33],[18,34,18,37],[1,29,2,37],[3,28,3,37],[4,30,6,37],[8,30,8,37],[12,30,12,33],[12,34,12,37],[85,0,85,20],[86,0,86,20],[87,0,87,20],[40,0,51,0],[50,10,50,16],[52,0,52,20],[53,0,70,0],[71,0,71,20],[72,0,83,0],[73,1,73,5],[82,10,82,16],[2,0,19,0],[20,0,20,20],[21,0,38,0],[84,0,84,20],[39,0,39,20],[0,0,0,1],[0,2,0,8],[0,9,0,11],[0,12,0,20],[1,0,1,1],[1,2,1,6],[1,8,1,11],[1,12,1,13],[1,14,1,15],[1,16,1,17],[1,18,1,20]]}
["Stream:",null,null,null,null,null,null,null,null,"Location:"]
["Observers:",null,null,null,null,null,null,"Date:",null,null,null,null,"Valley Type:",null,null,null,"Stream Type:",null,null,null,null,null,"This form is populated in RIVERMorph within the \"Ratios\" node by clicking on the \"Field Book\" button.  Copy the appropriate cells within the exported RIVERMorph \"Worksheet 2-4a\" and paste into cell A1.  These values are then automatically transferred to the \"Design Table\" column for the existing reach.",null,null,null,null,null,null,"Instructions to Complete Bed Feature Dimensions (Worksheet 2-4a)"]
[]
[null,"Riffle Dimensions*, **, ***",null,null,null,null,"Mean","Min","Max","Riffle Dimensions & Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min","Max",null,null,null,null,null,null,null,null,"Riffle Dimensions"]
[null,"Riffle Width (Wbkf)",null,null,null,null,null,null,null,"ft","Riffle Cross-Sectional Area (Abkf) (ft2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.","Survey Riffle cross-sections; be sure to select and survey only those cross-sections that are representative of the reach, determined during the \"toothpick survey.\"  Multiple Riffle cross-sections are needed to determine an average and a range of values that represent Riffle dimensions."]
[]
[null,"Riffle Mean Depth (dbkf)",null,null,null,null,null,null,null,"ft","Riffle Width/Depth Ratio (Wbkf / dbkf)"]
[]
[null,"Riffle Maximum Depth (dmax)",null,null,null,null,null,null,null,"ft","Riffle Max Depth to Riffle Mean Depth (dmax / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.","Plot all Riffle cross-sections."]
[]
[null,"Width of Flood-Prone Area (Wfpa)",null,null,null,null,null,null,null,"ft","Entrenchment Ratio (Wfpa / Wbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.","For each Riffle cross-section, calculate all dimensions and dimensionless ratios:"]
[]
[null,"Riffle Inner Berm Width (Wib)",null,null,null,null,null,null,null,"ft","Riffle Inner Berm Width to Riffle Width (Wib / Wbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i. Riffle Width (Wbkf)",null,null,null,"ii. Riffle Mean Depth (dbkf)"]
[]
[null,"Riffle Inner Berm Depth (dib)",null,null,null,null,null,null,null,"ft","Riffle Inner Berm Depth to Mean Depth (dib / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"iii. Riffle Cross-Sectional Area (Abkf)",null,null,null,"iv. Riffle Width/Depth Ratio (Wbkf/dbkf)"]
[]
[null,"Riffle Inner Berm Area (Aib)",null,null,null,null,null,null,null,"ft2","Riffle Inner Berm Area to Riffle Area (Aib / Abkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v. Riffle Maximum Depth (dmax)",null,null,null,"vi. Riffle Max Depth to Riffle Mean Depth (dmax/dbkf)"]
[]
[null,"Riffle Inner Berm W/D Ratio (Wib / dib)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"vii. Width of Flood-Prone Area (Wfpa)",null,null,null,"viii.  Entrenchment Ratio (Wfpa/Wbkf)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ix. Riffle Inner Berm Width (Wib)",null,null,null,"x. Riffle Inner Berm Width to Riffle Width (Wib/Wbkf)"]
[]
[null,"Pool Dimensions*, **, ***",null,null,null,null,"Mean","Min","Max","Pool Dimensions & Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Pool Width (Wbkfp)",null,null,null,null,null,null,null,"ft","Pool Width to Riffle Width (Wbkfp / Wbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xi. Riffle Inner Berm Depth (dib)",null,null,null,"xii. Riffle Inner Berm Depth to Mean Depth (dib/dbkf)"]
[]
[null,"Pool Mean Depth (dbkfp)",null,null,null,null,null,null,null,"ft","Pool Mean Depth to Riffle Mean Depth (dbkfp / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xiii. Riffle Inner Berm Area (Aib)",null,null,null,"xiv. Riffle Inner Berm Area to Riffle Area (Aib/Abkf)"]
[]
[null,"Pool Cross-Sectional Area (Abkfp)",null,null,null,null,null,null,null,"ft","Pool Area to Riffle Area (Abkfp / Abkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xv. Riffle Inner Berm Width/Depth Ratio (Wib/dib)"]
[]
[null,"Pool Maximum Depth (dmaxp)",null,null,null,null,null,null,null,"ft","Pool Max Depth to Riffle Mean Depth (dmaxp / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.","Determine the mean, minimum and maximum Riffle dimensions that represent the values from all Riffle cross-sections.  Complete the \"Riffle Dimensions\" section in Worksheet 2-4a using the determined mean, minimum and maximum values.  "]
[]
[null,"Pool Inner Berm Width (Wibp)",null,null,null,null,null,null,null,"ft","Pool Inner Berm Width to Pool Width (Wibp / Wbkfp)"]
[]
[null,"Pool Inner Berm Depth (dibp)",null,null,null,null,null,null,null,"ft","Pool Inner Berm Depth to Pool Depth (dibp / dbkfp)"]
[]
[null,"Pool Inner Berm Area (Aibp)",null,null,null,null,null,null,null,"ft2","Pool Inner Berm Area to Pool Area (Aibp / Abkfp)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pool Dimensions"]
[]
[null,"Point Bar Slope (Spb)",null,null,null,null,null,null,null,"ft/ft","Pool Inner Berm Width/Depth Ratio (Wibp / dibp)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.","Survey Pool cross-sections; be sure to select and survey only those cross-sections that are representative of the reach, determined during the \"toothpick survey.\"  Multiple Pool cross-sections are needed to determine an average and a range of values that represent pool dimensions."]
[]
[]
[]
[null,"Run Dimensions*",null,null,null,null,"Mean","Min","Max","Run Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Run Width (Wbkfr)",null,null,null,null,null,null,null,"ft","Run Width to Riffle Width (Wbkfr / Wbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.","Plot all Pool cross-sections."]
[]
[null,"Run Mean Depth (dbkfr)",null,null,null,null,null,null,null,"ft","Run Mean Depth to Riffle Mean Depth (dbkfr / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.","For each Pool cross-section, calculate all dimensions and dimensionless ratios:"]
[]
[null,"Run Cross-Sectional Area (Abkfr)",null,null,null,null,null,null,null,"ft","Run Area to Riffle Area (Abkfr / Abkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i. Pool Width (Wbkfp)",null,null,null,"ii. Pool Width to Riffle Width (Wbkfp/Wbkf)*"]
[]
[null,"Run Maximum Depth (dmaxr)",null,null,null,null,null,null,null,"ft","Run Max Depth to Riffle Mean Depth (dmaxr / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"iii. Pool Mean Depth (dbkfp)",null,null,null,"iv. Pool Mean Depth to Riffle Mean Depth (dbkfp/dbkf)*"]
[]
[null,"Run Width/Depth Ratio (Wbkfr / dbkfr)",null,null,null,null,null,null,null,"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v. Pool Cross-Sectional Area (Abkfp)",null,null,null,"vi. Pool Area to Riffle Area (Abkfp/Abkf)*"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"vii. Pool Maximum Depth (dmaxp)",null,null,null,"viii. Pool Max Depth to Riffle Mean Depth (dmaxp/dbkf)*"]
[]
[null,"Glide Dimensions*",null,null,null,null,"Mean","Min","Max","Glide Dimensions & Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Glide Width (Wbkfg)",null,null,null,null,null,null,null,"ft","Glide Width to Riffle Width (Wbkfg / Wbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ix. Pool Inner Berm Width (Wibp)",null,null,null,"x. Pool Inner Berm Width to Pool Width (Wibp/Wbkfp)"]
[]
[null,"Glide Mean Depth (dbkfg)",null,null,null,null,null,null,null,"ft","Glide Mean Depth to Riffle Mean Depth (dbkfg / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xi. Pool Inner Berm Depth (dibp)",null,null,null,"xii. Pool Inner Berm Depth to Pool Depth (dibp/dbkfp)"]
[]
[null,"Glide Cross-Sectional Area (Abkfg)",null,null,null,null,null,null,null,"ft","Glide Area to Riffle Area (Abkfg / Abkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xiii. Pool Inner Berm Area (Aibp)",null,null,null,"xiv. Pool Inner Berm Area to Pool Area (Aibp/Abkfp)"]
[]
[null,"Glide Maximum Depth (dmaxg)",null,null,null,null,null,null,null,"ft","Glide Max Depth to Riffle Mean Depth (dmaxg / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xv. Point Bar Slope (Spb)",null,null,null,"xvi. Pool Inner Berm Width/Depth Ratio (Wibp/dibp)"]
[]
[null,"Glide Width/Depth Ratio (Wbkfg / dbkfg)",null,null,null,null,null,null,null,"ft/ft","Glide Inner Berm Width/Depth Ratio (Wibg / dibg)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*","The Riffle Width (Wbkf), Riffle Mean Depth (dbkf), and Riffle Area (Abkf) to create the pool dimensionless ratios (bolded above) use the respective mean Riffle dimensions from the \"Riffle Dimensions\" section in Worksheet 2-4a.  These values represent the mean Riffle Width, Mean Depth and Area determined from all Riffle cross-sections."]
[]
[null,"Glide Inner Berm Width (Wibg)",null,null,null,null,null,null,null,"ft","Glide Inner Berm Width to Glide Width (Wibg/Wbkfg)"]
[]
[null,"Glide Inner Berm Depth (dibg)",null,null,null,null,null,null,null,"ft","Glide Inner Berm Depth to Glide Depth (dibg / dbkfg)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.","Determine the mean, minimum and maximum Pool dimensions that represent the values from all Riffle cross-sections.  Complete the \"Pool Dimensions\" section in Worksheet 2-4a using the determined mean, minimum and maximum values.  "]
[null,"Glide Inner Berm Area (Aibg)",null,null,null,null,null,null,null,"ft2","Glide Inner Berm Area to Glide Area (Aibg / Abkfg)"]
[]
[]
[]
[null,"Step Dimensions**",null,null,null,null,"Mean","Min","Max","Step Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Step Width (Wbkfs)",null,null,null,null,null,null,null,"ft","Step Width to Riffle Width (Wbkfs / Wbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Run, Glide & Step Dimensions"]
[]
[null,"Step Mean Depth (dbkfs)",null,null,null,null,null,null,null,"ft","Step Mean Depth to Riffle Mean Depth (dbkfs / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The instructions to complete the \"Run Dimensions\", \"Glide Dimensions\" and \"Step Dimensions\" in Worksheet 2-4a are similar to the Pool Instructions in 1–4 above, but instead are calculated for the respective bed feature.  Similar to the Pool dimensionless ratio calculations, the Riffle Width (Wbkf), Riffle Mean Depth (dbkf), and Riffle Area (Abkf) to create the bed feature dimensionless ratios use the respective mean Riffle dimensions from the \"Riffle Dimensions\" section in Worksheet 2-4a.  These values represent the mean Riffle Width, Mean Depth and Area determined from all Riffle cross-sections."]
[]
[null,"Step Cross-Sectional Area (Abkfs)",null,null,null,null,null,null,null,"ft","Step Area to Riffle Area (Abkfs / Abkf)"]
[]
[null,"Step Maximum Depth (dmaxs)",null,null,null,null,null,null,null,"ft","Step Max Depth to Riffle Mean Depth (dmaxs / dbkf)"]
[]
[null,"Step Width/Depth Ratio (Wbkfs / dbkfs)",null,null,null,null,null,null,null,"ft/ft"]
[]
["*Riffle–Pool system (i.e., C, E, F stream types) bed features include riffles, runs, pools and glides."]
["**Step–Pool system (i.e., A, B, G stream types) bed features include riffles, rapids, chutes, pools and steps (note: include rapids and chutes in riffle category)."]
["***Convergence-Divergence system (i.e., D stream types) bed features include riffles and pools; cross-sections taken at riffles for classification purposes."]
["****Mean values are used as the normalization parameter for all dimensionless ratios; e.g., minimum pool width to riffle width ratio uses the mean riffle width value."]

{"sheet":"Existing b","index":5,"n_rows":76,"n_cols":23,"rows_kept":76,"cut":false,"hidden":false,"merged":[[1,22,8,26],[72,17,72,18],[76,0,76,20],[72,1,72,3],[72,4,72,5],[72,6,72,7],[72,8,72,9],[72,12,72,13],[72,14,72,15],[61,0,73,0],[61,17,61,19],[66,14,66,15],[66,17,66,18],[68,17,68,18],[70,1,70,3],[70,4,70,5],[70,6,70,7],[70,8,70,9],[70,12,70,13],[70,14,70,15],[70,17,70,18],[68,14,68,15],[66,1,66,3],[66,4,66,5],[66,6,66,7],[66,8,66,9],[66,12,66,13],[68,1,68,3],[68,4,68,5],[68,6,68,7],[68,8,68,9],[68,12,68,13],[64,14,64,15],[62,1,62,3],[62,4,62,5],[62,6,62,7],[64,17,64,18],[64,1,64,3],[64,4,64,5],[64,6,64,7],[64,8,64,9],[64,12,64,13],[57,9,57,16],[59,0,59,20],[62,8,62,9],[62,12,62,13],[62,14,62,15],[62,17,62,18],[28,0,28,20],[29,0,56,0],[30,4,30,5],[30,13,30,14],[32,4,32,5],[32,7,32,12],[32,13,32,14],[34,7,34,10],[35,7,35,10],[49,9,49,16],[51,9,51,16],[53,9,53,16],[55,9,55,16],[9,0,9,20],[10,0,27,0],[18,1,18,4],[18,9,18,16],[20,9,20,16],[22,9,22,16],[24,9,24,16],[26,1,26,4],[26,9,26,16],[3,0,8,0],[5,11,5,12],[5,17,5,19],[7,11,7,12],[7,17,7,18],[0,0,0,1],[0,2,0,8],[0,9,0,11],[0,12,0,20],[1,0,1,1],[1,2,1,6],[1,8,1,11],[1,12,1,13],[1,14,1,15],[1,16,1,17],[1,18,1,20]]}
["Stream:",null,"",null,null,null,null,null,null,"Location:",null,null,""]
["Observers:",null,"",null,null,null,null,"Date:","",null,null,null,"Valley Type:",null,"",null,"Stream Type:",null,"",null,null,null,"This form is populated in RIVERMorph within the \"Ratios\" node by clicking on the \"Field Book\" button.  Copy the appropriate cells within the exported RIVERMorph \"Worksheet 2-4b\" and paste into cell A1.  These values are then automatically transferred to the \"Design Table\" column for the existing reach."]
[]
[]
[]
[null,"Streamflow: Estimated Mean Velocity at Bankfull Stage (ūbkf)",null,null,null,null,null,null,null,null,null,null,null,"ft/sec","Estimation Method"]
[]
[null,"Streamflow: Estimated Discharge at Bankfull Stage (Qbkf)",null,null,null,null,null,null,null,null,null,null,null,"cfs","Drainage Area",null,null,null,null,"mi2"]
[]
[]
[]
[null,"Geometry",null,null,null,"Mean","Min","Max",null,"Dimensionless Geometry Ratios",null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Linear Wavelength (l)",null,null,null,null,null,null,"ft","Linear Wavelength to Riffle Width (l / Wbkf)"]
[]
[null,"Stream Meander Length (Lm)",null,null,null,null,null,null,"ft","Stream Meander Length Ratio (Lm / Wbkf)"]
[]
[null,"Radius of Curvature (Rc)",null,null,null,null,null,null,"ft","Radius of Curvature to Riffle Width (Rc / Wbkf)"]
[]
[null,"Belt Width (Wblt)",null,null,null,null,null,null,"ft","Meander Width Ratio (Wblt / Wbkf)"]
[]
[null,"Arc Length (La)",null,null,null,null,null,null,"ft","Arc Length to Riffle Width (La / Wbkf)"]
[]
[null,"Riffle Length (Lr)",null,null,null,null,null,null,"ft","Riffle Length to Riffle Width (Lr / Wbkf)"]
[]
[null,"Individual Pool Length (Lp)",null,null,null,null,null,null,"ft","Individual Pool Length to Riffle Width (Lp / Wbkf)"]
[]
[null,"Pool to Pool Spacing (Ps)",null,null,null,null,null,null,"ft","Pool to Pool Spacing to Riffle Width (Ps / Wbkf)"]
[]
[]
[]
[null,"Valley Slope (Sval)",null,null,null,null,"ft/ft","Average Water Surface Slope (S)",null,null,null,null,null,null,null,"ft/ft","Sinuosity (Sval / S)"]
[]
[null,"Stream Length (SL)",null,null,null,null,"ft","Valley Length (VL)",null,null,null,null,null,null,null,"ft","Sinuosity (SL / VL)"]
[]
[null,"Low Bank Height",null,null,"start",null,"ft"," Max Bankfull Depth",null,null,null,"start",null,"ft","Bank-Height Ratio (BHR)",null,null,null,"start"]
[null,"(LBH)",null,null,"end",null,"ft","(dmax)",null,null,null,"end",null,"ft","(LBH / dmax)",null,null,null,"end"]
[]
[null,"Facet Slopes",null,null,null,"Mean","Min","Max","Dimensionless Facet Slope Ratios",null,null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Riffle Slope (Srif)",null,null,null,null,null,null,"ft/ft","Riffle Slope to Average Water Surface Slope (Srif / S)"]
[]
[null,"Run Slope (Srun)",null,null,null,null,null,null,"ft/ft","Run Slope to Average Water Surface Slope (Srun / S)"]
[]
[null,"Pool Slope (Sp)",null,null,null,null,null,null,"ft/ft","Pool Slope to Average Water Surface Slope (Sp / S)"]
[]
[null,"Glide Slope (Sg)",null,null,null,null,null,null,"ft/ft","Glide Slope to Average Water Surface Slope (Sg / S)"]
[]
[null,"Step Slope (Ss)",null,null,null,null,null,null,"ft/ft","Step Slope to Average Water Surface Slope (Ss / S)"]
[]
[null,"Max Depthsa",null,null,null,"Mean","Min","Max","Dimensionless Depth Ratios",null,null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Max Riffle Depth (dmax)",null,null,null,null,null,null,"ft","Max Riffle Depth to Mean Riffle Depth (dmax / dbkf)"]
[]
[null,"Max Run Depth (dmaxr)",null,null,null,null,null,null,"ft","Max Run Depth to Mean Riffle Depth (dmaxr / dbkf)"]
[]
[null,"Max Pool Depth (dmaxp)",null,null,null,null,null,null,"ft","Max Pool Depth to Mean Riffle Depth (dmaxp / dbkf)"]
[]
[null,"Max Glide Depth (dmaxg)",null,null,null,null,null,null,"ft","Max Glide Depth to Mean Riffle Depth (dmaxg / dbkf)"]
[]
[null,"Max Step Depth (dmaxs)",null,null,null,null,null,null,"ft","Max Step Depth to Mean Riffle Depth (dmaxs / dbkf)"]
[]
[]
[]
[null,null,null,null,"Reachb",null,"Rifflec",null,"Bar",null,null,null,"Reachb",null,"Rifflec",null,"Bar","Protrusion Heightd"]
[null,"% Silt/Clay",null,null,null,null,null,null,null,null,null,"D16",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Sand",null,null,null,null,null,null,null,null,null,"D35",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Gravel",null,null,null,null,null,null,null,null,null,"D50",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Cobble",null,null,null,null,null,null,null,null,null,"D84",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Boulder",null,null,null,null,null,null,null,null,null,"D95",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Bedrock",null,null,null,null,null,null,null,null,null,"D100",null,null,null,null,null,null,null,"mm"]
[]
["a Min, max & mean depths are measured from Thalweg to bankfull at mid-point of feature for riffles and runs, the deepest part of pools, & at the tail-out of glides."]
["b Composite sample of riffles and pools within the designated reach.",null,null,null,null,null,null,null,null,null,null,"c Active bed of a riffle.",null,null,null,"d Height of roughness feature above bed."]

{"sheet":"Existing Competence","index":6,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,13,3,21],[25,3,26,10],[27,3,28,10],[29,3,30,10],[31,3,32,10],[32,13,33,21],[33,6,33,7],[24,1,24,2],[24,3,24,10],[12,1,12,10],[13,1,13,2],[14,1,14,2],[15,1,15,2],[15,8,15,9],[17,1,17,10],[18,1,18,2],[19,1,19,10],[20,1,20,2],[21,6,21,7],[23,1,23,10],[8,1,8,2],[8,4,8,10],[9,1,9,2],[9,4,9,10],[10,1,10,2],[10,4,10,10],[7,1,7,2],[7,4,7,7],[1,3,1,6],[1,7,1,8],[1,9,1,10],[2,3,2,6],[2,7,2,8],[2,9,2,10],[3,3,3,6],[3,9,3,10],[4,1,4,10],[5,1,5,2],[5,4,5,10],[6,1,6,2],[6,4,6,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"This form is populated in RIVERMorph within the \"Competence\" node by clicking on the \"Worksheet 3-14\" button.  Copy the appropriate cells within the exported RIVERMorph \"Worksheet 3-14\" and paste into cell A1.  These values are then automatically transferred to the \"Design Table\" column for the existing reach."]
[null,"Stream:  ",null,null,null,null,null,"Stream Type:"]
[null,"Location:  ",null,null,null,null,null,"Valley Type:"]
[null,"Observers:",null,null,null,null,null,null,"Date:"]
[null,"Enter Required Information for Existing Condition"]
[null,null,null,"D50","Riffle bed material D50 (mm)"]
[null,null,null,"D50","Bar sample D50 (mm)"]
[null,null,null,"Dmax","Largest particle from bar sample (ft)",null,null,null,null,"(mm)","304.8 mm/ft"]
[null,null,null,"S","Existing bankfull water surface slope (ft/ft)"]
[null,null,null,"d","Existing bankfull mean depth (ft)"]
[null,1.65,null,null,"Immersed specific gravity of sediment"]
[]
[null,"Select the Appropriate Equation and Calculate Critical Dimensionless Shear Stress"]
[null,{"$f":"IF(OR(B6=\"\",B7=\"\"),\"\",B6/B7)","v":""},null,null,"Range:  3 – 7",null," Use EQUATION 1:",null,"t* = 0.0834 (                ) –0.872"]
[null,{"$f":"IF(OR(I8=\"\",B6=\"\"),\"\",I8/B6)","v":""},null,"Dmax/D50 ","Range:  1.3 – 3.0",null," Use EQUATION 2:",null,"t* = 0.0384 (Dmax/D50) –0.887"]
[null,null,null,"t*","Bankfull Dimensionless Shear Stress",null,null,null,"EQUATION USED:"]
[]
[null,"Calculate Bankfull Mean Depth Required for Entrainment of Largest Particle in Bar Sample"]
[null,null,null,"d","Required bankfull mean depth (ft)                                            ",null,null,null,null,null," (use Dmax in ft)"]
[null,"Calculate Bankfull Water Surface Slope Required for Entrainment of Largest Particle in Bar Sample"]
[null,null,null,"S","Required bankfull water surface slope (ft/ft)",null,null,null,null,null,"(use Dmax in ft)"]
[null,null,null,"Check:","Stable ","Aggrading ","Degrading "]
[]
[null,"Sediment Competence Using Dimensional Shear Stress"]
[null,{"$f":"IF(OR(B10=\"\",B9=\"\"),\"\",62.4*B10*B9)","v":""},null,"Bankfull shear stress t = gdS (lbs/ft2) (substitute hydraulic radius, R, with mean depth, d )                             g = 62.4, d = existing depth, S = existing slope"]
[null,"Shields","Rosgen","Predicted largest moveable particle size (mm) at bankfull shear stress t (Figure 5-49)"]
[]
[null,"Shields","Rosgen","Predicted shear stress required to initiate movement of measured Dmax (mm) (Figure 5-49)"]
[]
[null,"Shields","Rosgen","Predicted mean depth required to initiate movement of measured Dmax (mm)                                                     t = predicted shear stress, g = 62.4, S = existing slope"]
[null,{"$f":"IF(OR(B29=\"\",B9=\"\"),\"\",B29/(62.4*B9))","v":""},{"$f":"IF(OR(C29=\"\",B9=\"\"),\"\",C29/(62.4*B9))","v":""}]
[null,"Shields","Rosgen","Predicted slope required to initiate movement of measured Dmax (mm)                                                t = predicted shear stress, g = 62.4, d = existing depth"]
[null,{"$f":"IF(OR(B29=\"\",B10=\"\"),\"\",B29/(62.4*B10))","v":""},{"$f":"IF(OR(C29=\"\",B10=\"\"),\"\",C29/(62.4*B10))","v":""},null,null,null,null,null,null,null,null,null,null,"Figure 3-11.  Critical shear stress required to initiate movement of bed-material grains following the Shields relation (Leopold et al., 1964), as modified by field data from Rosgen (Rosgen, 2006b)."]
[null,null,null,"Check:","Stable ","Aggrading ","Degrading "]

{"sheet":"Existing Bank Erosion","index":7,"n_rows":24,"n_cols":44,"rows_kept":24,"cut":false,"hidden":false,"merged":[[20,34,20,41],[20,43,20,50],[21,0,21,6],[22,0,22,6],[23,0,23,6],[20,0,20,6],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[14,1,14,2],[3,0,3,2],[4,0,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[2,2,2,4],[0,30,4,33],[0,2,0,5],[0,7,0,9],[1,0,1,1],[1,2,1,3],[1,4,1,5],[1,6,1,7]]}
["Stream:",null,null,null,null,null,"Location:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This form is populated in RIVERMorph within the \"BEHI\" node by clicking on the \"Worksheet 3-13\" button.  Copy the appropriate cells within the exported RIVERMorph \"Worksheet 3-13\" and paste into cell A1.  These values are then automatically transferred to the \"Design Table\" column for the existing reach."]
["Graph Used:",null,null,null,"Total Stream Length (ft):",null,null,null,"Date:"]
["Observers:",null,null,null,null,"Valley Type:",null,null,"Stream Type:"]
["(1)",null,null,"(2)","(3)","(4)","(5)","(6)","(7)","(8)"]
["Station (ft)",null,null,"BEHI rating (Worksheet 5-16) (adjective)","NBS rating (Worksheet 5-17) (adjective)","Bank erosion rate (Figure 5-34 or 5-35) (ft/yr)","Length of bank (ft)","Study bank height (ft)","Erosion subtotal [(4)×(5)×(6)] (ft3/yr)","Erosion Rate (tons/yr/ft) {[(7)/27] × 1.3 / (5)}","NBS","VERY LOW","LOW","MOD","HIGH","EX","EX/EX"]
["1.",null,null,null,null,null,null,null,null,null,{"$f":"IF(E6=\"Very low\",1,IF(E6=\"Low\",2,IF(E6=\"Moderate\",3,IF(E6=\"high\",4,IF(E6=\"very high\",5,IF(E6=\"extreme\",6,\"\"))))))","v":""},{"$f":"0.0007*EXP(0.8538*K6)","v":{"$error":"#VALUE!"}},{"$f":"0.0082*EXP(0.7349*K6)","v":{"$error":"#VALUE!"}},{"$f":"0.0556*EXP(0.5057*K6)","v":{"$error":"#VALUE!"}},{"$f":"0.109*EXP(0.4159*K6)","v":{"$error":"#VALUE!"}},{"$f":"0.0642*EXP(0.9391*K6)","v":{"$error":"#VALUE!"}},{"$f":"0.8015*EXP(0.2061*K6)","v":{"$error":"#VALUE!"}}]
["2.",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["3.",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["4.",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["5.",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["6.",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["7.",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["8",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["9",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["10",null,null,null,null,{"$f":"IF(D15=\"VERY LOW\",L15,IF(D15=\"LOW\",M15,IF(D15=\"MODERATE\",N15,IF(D15=\"HIGH\",O15,IF(D15=\"VERY HIGH\",O15,IF(AND(D15=\"EXTREME\",E15=\"EXTREME\"),Q15,IF(D15=\"EXTREME\",P15,\"\")))))))","v":""},null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["11",null,null,null,null,"",null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["12",null,null,null,null,"",null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["13",null,null,null,null,"",null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["14",null,null,null,null,"",null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["15",null,null,null,null,"",null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Sum erosion subtotals in Column (7) for each BEHI/NBS combination",null,null,null,null,null,null,"Total Erosion (ft3/yr)",null,{"$f":"IF(OR(I21=\"\",G21=\"\"),\"\",I21/27*1.3/G21)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 3-9.  Relationship of BEHI and NBS to predict annual streambank erosion rates from Colorado data (1989) for streams found in sedimentary and/or metamorphic geology (Rosgen, 1996, 2001b, 2006b).",null,null,null,null,null,null,null,null,"Figure 3-10.  Relationship of BEHI and NBS to predict annual streambank erosion rates from Yellowstone National Park data (1989) for streams found in alpine glaciation and/or volcanism geology (Rosgen, 1996, 2001b, 2006b)."]
["Convert erosion in ft3/yr to yds3/yr  {divide Total Erosion (ft3/yr) by 27}",null,null,null,null,null,null,"Total Erosion (yds3/yr)",null,""]
["Convert erosion in yds3/yr to tons/yr  {multiply Total Erosion (yds3/yr) by 1.3}",null,null,null,null,null,null,"Total Erosion   (tons/yr)"]
["Calculate erosion per unit length of channel  {divide Total Erosion (tons/yr) by total length of stream (ft) surveyed}",null,null,null,null,null,null,"Total Erosion (tons/yr/ft)"]

{"sheet":"Reference a","index":8,"n_rows":88,"n_cols":23,"rows_kept":88,"cut":false,"hidden":false,"merged":[[1,22,6,26],[39,0,39,20],[85,0,85,20],[86,0,86,20],[87,0,87,20],[40,0,51,0],[50,10,50,16],[52,0,52,20],[53,0,70,0],[71,0,71,20],[72,0,83,0],[73,1,73,5],[82,10,82,16],[84,0,84,20],[20,0,20,20],[21,0,38,0],[2,0,19,0],[0,0,0,1],[0,2,0,8],[0,9,0,11],[0,12,0,20],[1,0,1,1],[1,2,1,6],[1,8,1,11],[1,12,1,13],[1,14,1,15],[1,16,1,17],[1,18,1,20]]}
["Stream:",null,null,null,null,null,null,null,null,"Location:"]
["Observers:",null,null,null,null,null,null,"Date:",null,null,null,null,"Valley Type:",null,null,null,"Stream Type:",null,null,null,null,null,"This form is populated in RIVERMorph within the \"Ratios\" node by clicking on the \"Field Book\" button.  Copy the appropriate cells within the exported RIVERMorph \"Worksheet 2-4a\" and paste into cell A1.  These values are then automatically transferred to the \"Design Table\" column for the reference reach."]
[]
[null,"Riffle Dimensions*, **, ***",null,null,null,null,"Mean","Min","Max","Riffle Dimensions & Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Riffle Width (Wbkf)",null,null,null,null,null,null,null,"ft","Riffle Cross-Sectional Area (Abkf) (ft2)"]
[]
[null,"Mean Riffle Depth (dbkf)",null,null,null,null,null,null,null,"ft","Riffle Width/Depth Ratio (Wbkf / dbkf)"]
[]
[null,"Maximum Riffle Depth (dmax)",null,null,null,null,null,null,null,"ft","Max Riffle Depth to Mean Riffle Depth (dmax / dbkf)"]
[]
[null,"Width of Flood-Prone Area (Wfpa)",null,null,null,null,null,null,null,"ft","Entrenchment Ratio (Wfpa / Wbkf)"]
[]
[null,"Riffle Inner Berm Width (Wib)",null,null,null,null,null,null,null,"ft","Riffle Inner Berm Width to Riffle Width (Wib / Wbkf)"]
[]
[null,"Riffle Inner Berm Depth (dib)",null,null,null,null,null,null,null,"ft","Riffle Inner Berm Depth to Mean Depth (dib / dbkf)"]
[]
[null,"Riffle Inner Berm Area (Aib)",null,null,null,null,null,null,null,"ft2","Riffle Inner Berm Area to Riffle Area (Aib / Abkf)"]
[]
[null,"Riffle Inner Berm W/D Ratio (Wib / dib)"]
[]
[]
[]
[null,"Pool Dimensions*, **, ***",null,null,null,null,"Mean","Min","Max","Pool Dimensions & Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Pool Width (Wbkfp)",null,null,null,null,null,null,null,"ft","Pool Width to Riffle Width (Wbkfp / Wbkf)",null,null,null,null,null,null,null,"",""]
[]
[null,"Mean Pool Depth (dbkfp)",null,null,null,null,null,null,null,"ft","Mean Pool Depth to Mean Riffle Depth (dbkfp / dbkf)",null,null,null,null,null,null,null,"",""]
[]
[null,"Pool Cross-Sectional Area (Abkfp)",null,null,null,null,null,null,null,"ft","Pool Area to Riffle Area (Abkfp / Abkf)",null,null,null,null,null,null,null,"",""]
[]
[null,"Maximum Pool Depth (dmaxp)",null,null,null,null,null,null,null,"ft","Max Pool Depth to Mean Riffle Depth (dmaxp / dbkf)",null,null,null,null,null,null,null,"",""]
[]
[null,"Pool Inner Berm Width (Wibp)",null,null,null,null,null,null,null,"ft","Pool Inner Berm Width to Pool Width (Wibp / Wbkfp)"]
[]
[null,"Pool Inner Berm Depth (dibp)",null,null,null,null,null,null,null,"ft","Pool Inner Berm Depth to Pool Depth (dibp / dbkfp)"]
[]
[null,"Pool Inner Berm Area (Aibp)",null,null,null,null,null,null,null,"ft2","Pool Inner Berm Area to Pool Area (Aibp / Abkfp)"]
[]
[null,"Point Bar Slope (Spb)",null,null,null,null,null,null,null,"ft/ft","Pool Inner Berm Width/Depth Ratio (Wibp / dibp)"]
[]
[]
[]
[null,"Run Dimensions*",null,null,null,null,"Mean","Min","Max","Run Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Run Width (Wbkfr)",null,null,null,null,null,null,null,"ft","Run Width to Riffle Width (Wbkfr / Wbkf)",null,null,null,null,null,null,null,"",""]
[]
[null,"Mean Run Depth (dbkfr)",null,null,null,null,null,null,null,"ft","Mean Run Depth to Mean Riffle Depth (dbkfr / dbkf)",null,null,null,null,null,null,null,"",""]
[]
[null,"Run Cross-Sectional Area (Abkfr)",null,null,null,null,null,null,null,"ft","Run Area to Riffle Area (Abkfr / Abkf)",null,null,null,null,null,null,null,"",""]
[]
[null,"Maximum Run Depth (dmaxr)",null,null,null,null,null,null,null,"ft","Max Run Depth to Mean Riffle Depth (dmaxr / dbkf)",null,null,null,null,null,null,null,"",""]
[]
[null,"Run Width/Depth Ratio (Wbkfr / dbkfr)",null,null,null,null,null,null,null,"ft"]
[]
[]
[]
[null,"Glide Dimensions*",null,null,null,null,"Mean","Min","Max","Glide Dimensions & Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Glide Width (Wbkfg)",null,null,null,null,null,null,null,"ft","Glide Width to Riffle Width (Wbkfg / Wbkf)",null,null,null,null,null,null,null,null,""]
[]
[null,"Mean Glide Depth (dbkfg)",null,null,null,null,null,null,null,"ft","Mean Glide Depth to Mean Riffle Depth (dbkfg / dbkf)",null,null,null,null,null,null,null,null,""]
[]
[null,"Glide Cross-Sectional Area (Abkfg)",null,null,null,null,null,null,null,"ft","Glide Area to Riffle Area (Abkfg / Abkf)",null,null,null,null,null,null,null,null,""]
[]
[null,"Maximum Glide Depth (dmaxg)",null,null,null,null,null,null,null,"ft","Max Glide Depth to Mean Riffle Depth (dmaxg / dbkf)",null,null,null,null,null,null,null,null,""]
[]
[null,"Glide Width/Depth Ratio (Wbkfg / dbkfg)",null,null,null,null,null,null,null,"ft/ft","Glide Inner Berm Width/Depth Ratio (Wibg / dibg)"]
[]
[null,"Glide Inner Berm Width (Wibg)",null,null,null,null,null,null,null,"ft","Glide Inner Berm Width to Glide Width (Wibg/Wbkfg)"]
[]
[null,"Glide Inner Berm Depth (dibg)",null,null,null,null,null,null,null,"ft","Glide Inner Berm Depth to Glide Depth (dibg / dbkfg)"]
[]
[null,"Glide Inner Berm Area (Aibg)",null,null,null,null,null,null,null,"ft2","Glide Inner Berm Area to Glide Area (Aibg / Abkfg)"]
[]
[]
[]
[null,"Step Dimensions**",null,null,null,null,"Mean","Min","Max","Step Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Step Width (Wbkfs)",null,null,null,null,null,null,null,"ft","Step Width to Riffle Width (Wbkfs / Wbkf)",null,null,null,null,null,null,"","",""]
[]
[null,"Mean Step Depth (dbkfs)",null,null,null,null,null,null,null,"ft","Mean Step Depth to Riffle Depth (dbkfs / dbkf)",null,null,null,null,null,null,"","",""]
[]
[null,"Step Cross-Sectional Area (Abkfs)",null,null,null,null,null,null,null,"ft","Step Area to Riffle Area (Abkfs / Abkf)",null,null,null,null,null,null,"","",""]
[]
[null,"Maximum Step Depth (dmaxs)",null,null,null,null,null,null,null,"ft","Max Step Depth to Mean Riffle Depth (dmaxs / dbkf)",null,null,null,null,null,null,"","",""]
[]
[null,"Step Width/Depth Ratio (Wbkfs / dbkfs)"]
[]
["*Riffle–Pool system (i.e., C, E, F stream types) bed features include riffles, runs, pools and glides."]
["**Step–Pool system (i.e., A, B, G stream types) bed features include riffles, rapids, chutes, pools and steps (note: include rapids and chutes in riffle category)."]
["***Convergence-Divergence system (i.e., D stream types) bed features include riffles and pools; cross-sections taken at riffles for classification purposes."]
["****Mean values are used as the normalization parameter for all dimensionless ratios; e.g., minimum pool width to riffle width ratio uses the mean riffle width value."]

{"sheet":"Reference b","index":9,"n_rows":76,"n_cols":23,"rows_kept":76,"cut":false,"hidden":false,"merged":[[68,17,68,18],[70,6,70,7],[72,1,72,3],[72,4,72,5],[72,6,72,7],[72,8,72,9],[72,12,72,13],[68,1,68,3],[68,4,68,5],[68,12,68,13],[68,14,68,15],[51,9,51,16],[53,9,53,16],[55,9,55,16],[64,17,64,18],[64,1,64,3],[64,4,64,5],[64,6,64,7],[64,8,64,9],[64,12,64,13],[62,12,62,13],[62,14,62,15],[62,17,62,18],[64,14,64,15],[62,1,62,3],[57,9,57,16],[59,0,59,20],[76,0,76,20],[70,8,70,9],[70,12,70,13],[70,14,70,15],[70,17,70,18],[72,17,72,18],[72,14,72,15],[62,4,62,5],[62,6,62,7],[61,0,73,0],[61,17,61,19],[66,14,66,15],[66,17,66,18],[70,1,70,3],[70,4,70,5],[66,8,66,9],[66,12,66,13],[62,8,62,9],[66,1,66,3],[66,4,66,5],[66,6,66,7],[68,6,68,7],[68,8,68,9],[29,0,56,0],[30,4,30,5],[1,0,1,1],[1,2,1,6],[1,8,1,11],[3,0,8,0],[5,11,5,12],[7,11,7,12],[9,0,9,20],[30,13,30,14],[32,4,32,5],[32,7,32,12],[32,13,32,14],[34,7,34,10],[35,7,35,10],[49,9,49,16],[28,0,28,20],[10,0,27,0],[18,1,18,4],[18,9,18,16],[20,9,20,16],[22,9,22,16],[24,9,24,16],[26,1,26,4],[26,9,26,16],[1,22,8,26],[0,0,0,1],[0,2,0,8],[0,9,0,11],[0,12,0,20],[1,12,1,13],[1,14,1,15],[1,16,1,17],[1,18,1,20],[5,17,5,19],[7,17,7,18]]}
["Stream:",null,null,null,null,null,null,null,null,"Location:"]
["Observers:",null,null,null,null,null,null,"Date:",null,null,null,null,"Valley Type:",null,null,null,"Stream Type:",null,null,null,null,null,"This form is populated in RIVERMorph within the \"Ratios\" node by clicking on the \"Field Book\" button.  Copy the appropriate cells within the exported RIVERMorph \"Worksheet 2-4b\" and paste into cell A1.  These values are then automatically transferred to the \"Design Table\" column for the reference reach."]
[]
[]
[]
[null,"Streamflow: Estimated Mean Velocity at Bankfull Stage (ubkf)",null,null,null,null,null,null,null,null,null,null,null,"ft/sec","Estimation Method"]
[]
[null,"Streamflow: Estimated Discharge at Bankfull Stage (Qbkf)",null,null,null,null,null,null,null,null,null,null,null,"cfs","Drainage Area",null,null,null,null,"mi2"]
[]
[]
[]
[null,"Geometry",null,null,null,"Mean","Min","Max",null,"Dimensionless Geometry Ratios",null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Linear Wavelength (l)",null,null,null,null,null,null,"ft","Linear Wavelength to Riffle Width (l / Wbkf)"]
[]
[null,"Stream Meander Length (Lm)",null,null,null,null,null,null,"ft","Stream Meander Length Ratio (Lm / Wbkf)"]
[]
[null,"Radius of Curvature (Rc)",null,null,null,null,null,null,"ft","Radius of Curvature to Riffle Width (Rc / Wbkf)"]
[]
[null,"Belt Width (Wblt)",null,null,null,null,null,null,"ft","Meander Width Ratio (Wblt / Wbkf)"]
[]
[null,"Arc Length (La)",null,null,null,null,null,null,"ft","Arc Length to Riffle Width (La / Wbkf)"]
[]
[null,"Riffle Length (Lr)",null,null,null,null,null,null,"ft","Riffle Length to Riffle Width (Lr / Wbkf)"]
[]
[null,"Individual Pool Length (Lp)",null,null,null,null,null,null,"ft","Individual Pool Length to Riffle Width (Lp / Wbkf)"]
[]
[null,"Pool to Pool Spacing (Ps)",null,null,null,null,null,null,"ft","Pool to Pool Spacing to Riffle Width (Ps / Wbkf)"]
[]
[]
[]
[null,"Valley Slope (Sval)",null,null,null,null,"ft/ft","Average Water Surface Slope (S)",null,null,null,null,null,null,null,"ft/ft","Sinuosity (Sval / S)"]
[]
[null,"Stream Length (SL)",null,null,null,null,"ft","Valley Length (VL)",null,null,null,null,null,null,null,"ft","Sinuosity (SL / VL)"]
[]
[null,"Low Bank Height",null,null,"start",null,"ft"," Max Bankfull Depth",null,null,null,"start",null,"ft","Bank-Height Ratio (BHR)",null,null,null,"start"]
[null,"(LBH)",null,null,"end",null,"ft","(dmax)",null,null,null,"end",null,"ft","(LBH / dmax)",null,null,null,"end"]
[]
[null,"Facet Slopes",null,null,null,"Mean","Min","Max","Dimensionless Facet Slope Ratios",null,null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Riffle Slope (Srif)",null,null,null,null,null,null,"ft/ft","Riffle Slope to Average Water Surface Slope (Srif / S)"]
[]
[null,"Run Slope (Srun)",null,null,null,null,null,null,"ft/ft","Run Slope to Average Water Surface Slope (Srun / S)"]
[]
[null,"Pool Slope (Sp)",null,null,null,null,null,null,"ft/ft","Pool Slope to Average Water Surface Slope (Sp / S)"]
[]
[null,"Glide Slope (Sg)",null,null,null,null,null,null,"ft/ft","Glide Slope to Average Water Surface Slope (Sg / S)"]
[]
[null,"Step Slope (Ss)",null,null,null,null,null,null,"ft/ft","Step Slope to Average Water Surface Slope (Ss / S)",null,null,null,null,null,null,null,"","",""]
[]
[null,"Max Depthsa",null,null,null,"Mean","Min","Max","Dimensionless Depth Ratios",null,null,null,null,null,null,null,null,"Mean","Min","Max"]
[null,"Max Riffle Depth (dmax)",null,null,null,null,null,null,"ft","Max Riffle Depth to Mean Riffle Depth (dmax / dbkf)"]
[]
[null,"Max Run Depth (dmaxr)",null,null,null,null,null,null,"ft","Max Run Depth to Mean Riffle Depth (dmaxr / dbkf)"]
[]
[null,"Max Pool Depth (dmaxp)",null,null,null,null,null,null,"ft","Max Pool Depth to Mean Riffle Depth (dmaxp / dbkf)"]
[]
[null,"Max Glide Depth (dmaxg)",null,null,null,null,null,null,"ft","Max Glide Depth to Mean Riffle Depth (dmaxg / dbkf)"]
[]
[null,"Max Step Depth (dmaxs)",null,null,null,null,null,null,"ft","Max Step Depth to Mean Riffle Depth (dmaxs / dbkf)",null,null,null,null,null,null,null,"","",""]
[]
[]
[]
[null,null,null,null,"Reachb",null,"Rifflec",null,"Bar",null,null,null,"Reachb",null,"Rifflec",null,"Bar","Protrusion Heightd"]
[null,"% Silt/Clay",null,null,null,null,null,null,null,null,null,"D16",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Sand",null,null,null,null,null,null,null,null,null,"D35",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Gravel",null,null,null,null,null,null,null,null,null,"D50",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Cobble",null,null,null,null,null,null,null,null,null,"D84",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Boulder",null,null,null,null,null,null,null,null,null,"D95",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Bedrock",null,null,null,null,null,null,null,null,null,"D100",null,null,null,null,null,null,null,"mm"]
[]
["a Min, max & mean depths are measured from Thalweg to bankfull at mid-point of feature for riffles and runs, the deepest part of pools, & at the tail-out of glides."]
["b Composite sample of riffles and pools within the designated reach.",null,null,null,null,null,null,null,null,null,null,"c Active bed of a riffle.",null,null,null,"d Height of roughness feature above bed."]

{"sheet":"Reference Competence","index":10,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[23,1,23,10],[17,1,17,10],[18,1,18,2],[19,1,19,10],[20,1,20,2],[21,6,21,7],[6,1,6,2],[6,4,6,10],[13,1,13,2],[14,1,14,2],[15,1,15,2],[15,8,15,9],[2,9,2,10],[3,3,3,6],[3,9,3,10],[4,1,4,10],[5,1,5,2],[5,4,5,10],[32,13,33,21],[25,3,26,10],[27,3,28,10],[29,3,30,10],[31,3,32,10],[33,6,33,7],[0,13,3,21],[7,1,7,2],[24,1,24,2],[24,3,24,10],[12,1,12,10],[8,1,8,2],[8,4,8,10],[9,1,9,2],[9,4,9,10],[10,1,10,2],[10,4,10,10],[7,4,7,7],[1,7,1,8],[1,9,1,10],[2,3,2,6],[2,7,2,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"This form is populated in RIVERMorph within the \"Competence\" node by clicking on the \"Worksheet 3-14\" button.  Copy the appropriate cells within the exported RIVERMorph \"Worksheet 3-14\" and paste into cell A1.  These values are then automatically transferred to the \"Design Table\" column for the reference reach."]
[null,"Stream:  ",null,null,null,null,null,"Stream Type:"]
[null,"Location:  ",null,null,null,null,null,"Valley Type:"]
[null,"Observers:",null,null,null,null,null,null,"Date:"]
[null,"Enter Required Information for Existing Condition"]
[null,null,null,"D50","Riffle bed material D50 (mm)"]
[null,null,null,"D50","Bar sample D50 (mm)"]
[null,null,null,"Dmax","Largest particle from bar sample (ft)",null,null,null,null,"(mm)","304.8 mm/ft"]
[null,null,null,"S","Existing bankfull water surface slope (ft/ft)"]
[null,null,null,"d","Existing bankfull mean depth (ft)"]
[null,1.65,null,null,"Immersed specific gravity of sediment"]
[]
[null,"Select the Appropriate Equation and Calculate Critical Dimensionless Shear Stress"]
[null,null,null,null,"Range:  3 – 7",null," Use EQUATION 1:",null,"t* = 0.0834 (                ) –0.872"]
[null,null,null,"Dmax/D50 ","Range:  1.3 – 3.0",null," Use EQUATION 2:",null,"t* = 0.0384 (Dmax/D50) –0.887"]
[null,null,null,"t*","Bankfull Dimensionless Shear Stress",null,null,null,"EQUATION USED:"]
[]
[null,"Calculate Bankfull Mean Depth Required for Entrainment of Largest Particle in Bar Sample"]
[null,null,null,"d","Required bankfull mean depth (ft)                                            ",null,null,null,null,null," (use Dmax in ft)"]
[null,"Calculate Bankfull Water Surface Slope Required for Entrainment of Largest Particle in Bar Sample"]
[null,null,null,"S","Required bankfull water surface slope (ft/ft)",null,null,null,null,null,"(use Dmax in ft)"]
[null,null,null,"Check:","Stable ","Aggrading ","Degrading "]
[]
[null,"Sediment Competence Using Dimensional Shear Stress"]
[null,null,null,"Bankfull shear stress t = gdS (lbs/ft2) (substitute hydraulic radius, R, with mean depth, d )                             g = 62.4, d = existing depth, S = existing slope"]
[null,"Shields","Rosgen","Predicted largest moveable particle size (mm) at bankfull shear stress t (Figure 5-49)"]
[]
[null,"Shields","Rosgen","Predicted shear stress required to initiate movement of measured Dmax (mm) (Figure 5-49)"]
[]
[null,"Shields","Rosgen","Predicted mean depth required to initiate movement of measured Dmax (mm)                                                     t = predicted shear stress, g = 62.4, S = existing slope"]
[]
[null,"Shields","Rosgen","Predicted slope required to initiate movement of measured Dmax (mm)                                                t = predicted shear stress, g = 62.4, d = existing depth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 3-11.  Critical shear stress required to initiate movement of bed-material grains following the Shields relation (Leopold et al., 1964), as modified by field data from Rosgen (Rosgen, 2006b)."]
[null,null,null,"Check:","Stable ","Aggrading ","Degrading "]

{"sheet":"Reference Bank Erosion","index":11,"n_rows":24,"n_cols":44,"rows_kept":24,"cut":false,"hidden":false,"merged":[[16,1,16,2],[20,34,20,41],[20,43,20,50],[21,0,21,6],[22,0,22,6],[23,0,23,6],[20,0,20,6],[17,1,17,2],[18,1,18,2],[19,1,19,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[0,30,4,33],[15,1,15,2],[0,2,0,5],[0,7,0,9],[1,0,1,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[2,2,2,4],[14,1,14,2],[3,0,3,2],[4,0,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2]]}
["Stream:",null,null,null,null,null,"Location:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This form is populated in RIVERMorph within the \"BEHI\" node by clicking on the \"Worksheet 3-13\" button.  Copy the appropriate cells within the exported RIVERMorph \"Worksheet 3-13\" and paste into cell A1.  These values are then automatically transferred to the \"Design Table\" column for the reference reach."]
["Graph Used:",null,null,null,"Total Bank Length (ft):",null,null,null,"Date:"]
["Observers:",null,null,null,null,"Valley Type:",null,null,"Stream Type:"]
["(1)",null,null,"(2)","(3)","(4)","(5)","(6)","(7)","(8)"]
["Station (ft)",null,null,"BEHI rating (Worksheet 5-16) (adjective)","NBS rating (Worksheet 5-17) (adjective)","Bank erosion rate (Figure 5-34 or 5-35) (ft/yr)","Length of bank (ft)","Study bank height (ft)","Erosion subtotal [(4)×(5)×(6)] (ft3/yr)","Erosion Rate (tons/yr/ft) {[(7)/27] × 1.3 / (5)}","NBS","VERY LOW","LOW","MOD","HIGH","EX","EX/EX"]
["1.",null,null,null,null,null,null,null,null,null,{"$f":"IF(E6=\"Very low\",1,IF(E6=\"Low\",2,IF(E6=\"Moderate\",3,IF(E6=\"high\",4,IF(E6=\"very high\",5,IF(E6=\"extreme\",6,\"\"))))))","v":""},{"$f":"0.0007*EXP(0.8538*K6)","v":{"$error":"#VALUE!"}},{"$f":"0.0082*EXP(0.7349*K6)","v":{"$error":"#VALUE!"}},{"$f":"0.0556*EXP(0.5057*K6)","v":{"$error":"#VALUE!"}},{"$f":"0.109*EXP(0.4159*K6)","v":{"$error":"#VALUE!"}},{"$f":"0.0642*EXP(0.9391*K6)","v":{"$error":"#VALUE!"}},{"$f":"0.8015*EXP(0.2061*K6)","v":{"$error":"#VALUE!"}}]
["2.",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["3.",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["4.",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["5.",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["6.",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["7.",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["8",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["9",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["10",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["11",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["12",null,null,null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["13",null,null,null,null,"",null,null,"","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["14",null,null,null,null,"",null,null,"","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["15",null,null,null,null,"",null,null,"","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Sum erosion subtotals in Column (7) for each BEHI/NBS combination",null,null,null,null,null,null,"Total Erosion (ft3/yr)",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 3-9.  Relationship of BEHI and NBS to predict annual streambank erosion rates from Colorado data (1989) for streams found in sedimentary and/or metamorphic geology (Rosgen, 1996, 2001b, 2006b).",null,null,null,null,null,null,null,null,"Figure 3-10.  Relationship of BEHI and NBS to predict annual streambank erosion rates from Yellowstone National Park data (1989) for streams found in alpine glaciation and/or volcanism geology (Rosgen, 1996, 2001b, 2006b)."]
["Convert erosion in ft3/yr to yds3/yr  {divide Total Erosion (ft3/yr) by 27}",null,null,null,null,null,null,"Total Erosion (yds3/yr)",null,""]
["Convert erosion in yds3/yr to tons/yr  {multiply Total Erosion (yds3/yr) by 1.3}",null,null,null,null,null,null,"Total Erosion   (tons/yr)"]
["Calculate erosion per unit length of channel  {divide Total Erosion (tons/yr) by total length of stream (ft) surveyed}",null,null,null,null,null,null,"Total Erosion (tons/yr/ft)"]